Creating ODBC link within SELECT statement

[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.

[Jim]

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