| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
list ODBC source
Hi all,
is there a way to programmatically list/change ODBC DataSource. My problem is: several excel file attached to an mdb database. Would like to change all the odbc links to a new mdb. tia for any help matis |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
list ODBC source
"matis" wrote in message ...
several excel file attached to an mdb database. How are they 'attached'? Linked tables in Jet? MS Query in Excel? ..? -- |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
list ODBC source
Hi
I found a web site that might answer your question. http://www.dicks-clicks.com/excel/ExternalData.htm Hope this helps, Regards - Grant |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing data source on ODBC query | Excel Discussion (Misc queries) | |||
| Changing Pivot Table Source from ODBC to .odc. | Excel Discussion (Misc queries) | |||
| change odbc data source | Excel Worksheet Functions | |||
| Try again: VBA to automatically install ODBC data source | Excel Programming | |||
| Retrieving data with SQL from ODBC source | Excel Programming | |||
Hybrid Mode
