| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.links,microsoft.public.excel.querydao,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assemble link from different cells and return value | Excel Worksheet Functions | |||
| Creating a link between cells in two different spreadsheets | Excel Discussion (Misc queries) | |||
| Question from MOS file E03C-1-1 , Creating data and contents | Excel Discussion (Misc queries) | |||
| creating drop down lists where you can select multiple values | Excel Discussion (Misc queries) | |||
| stop creating email link when @ sign is present | Excel Discussion (Misc queries) | |||
Linear Mode
