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 - 31 Jan 2006 18:54 GMT
Preacher,
Did you create your ODBC link using excel menus Data \ Get External
Data \ New Database Quey
?