Download SQL sproc to Excel

N

NeilR

Can anyone give me an easy way to provide an excel spreadsheet to
third parties with command buttons that would import various "tables"
of data from SQL stored procedures, but without giving them my SQL
connection information - ie with the SQL connection data "hard coded"
into the command buttons but not visible to the user?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting SQL data into Excel 1
import Excel worksheet to SQL Server table 7
Excel as front end and SQL Server as back end 0
Accessing the Data Connection Strings and Command Text (SQL) in VB 5
VBA Excel data to SQL Sever table 1
How do you code to get SQL Server data from ODBC Connection? 0
Importing Excel data with macros to SQL server 1
[Microsoft][ODBC SQL Server Driver]String data, right truncation 0

Top