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