Creating ODBC link within SELECT statement
Check this website. I use the DSN-less connections presented there and
they've worked fine on other PCs: http://www.carlprothman.net/Default.aspx?tabid=81 Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Preacher Man" wrote: 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. |
All times are GMT +1. The time now is 01:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com