Getting SQL data into Excel

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

Top