Creating ODBC link within SELECT statement

P

Preacher Man

Is this possible. To explain myself, here is my situation. I created an
Excel Spreadsheet that uses an ODBC link to a SQL database. In order for
anyone to use this file on their PC, that same ODBC link must be setup. Is
their some code I can use within a Select Statement that will allow me to
bypass having to create an ODBC on everyone's PC?

Thanks.
 
J

Jim

Preacher,
Did you create your ODBC link using excel menus Data \ Get External
Data \ New Database Quey
?
 
Top