Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting SQL data into Excel
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting SQL data into Excel
response in your previous post.
tim "NeilR" wrote in message ups.com... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
Email (LDAP) data download into a single Excel cell - data separat | Excel Worksheet Functions | |||
Updating Excel data with a newer version of Excel data | Excel Programming | |||
I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
Need advice : consolidating data from multiple CSV files in Excel - External data handling | Excel Programming |