DNS-Less Connection String

M

Mark

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
 

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

Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Programmatically set UID & PWD in existing ODBC DSN connection string. 1
DNS-Less Connection Help 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Connection String 4
Pass a command text in pivot table 0
Pivot Table connection String 0
SQL not importing records from ACCDB 2

Top