Getting SQL data into Excel

  • Thread starter Thread starter NeilR
  • Start date Start date
N

NeilR

Can anyone give me a simple way of providing third parties with an
excel spreadsheet with command buttons that would pull in data from
stored procedures in my online sql database, with the connection
properties "hard coded" so that they cannot see them - ie I don't want
to give them the user name and password to set up ODBC or let them see
the code that connects and runs the sproc?
 

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

Download SQL sproc to Excel 3
VBA Excel data to SQL Sever table 1
Excel as front end and SQL Server as back end 0
Excel ODBC driver created table/inserted data lost on application 1
[Microsoft][ODBC SQL Server Driver]String data, right truncation 0
dilemma with getting sql data 4
passing Nulls to SQL Server 2005 2
Get Access Data into Excel 1

Back
Top