Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DNS-Less Connection String
Hello,
I would like to have an excel spreadsheet call a query on SQL server and display the results. However, this report will be distributed in many locations. So, I would like to implement a DNS-less connection string instead of going around setting up ODBC on each machine. Can someone give me details on: 1. Where do I add the connection string 2. How can I add a query to excel without it asking me for the ODBC everytime 3. Does the call to the query have to take place in VBA or can I do it using the Import Data wizard? 4. Any other helpful info would be greatly appreciated. Thanks, Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a connection string? | Excel Discussion (Misc queries) | |||
Connection String | Excel Programming | |||
Can't get connection string right | Excel Programming | |||
Can't get connection string right | Excel Programming | |||
What is the connection string ? | Excel Programming |