ExcelBanter - list ODBC source

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - list ODBC source (https://www.excelbanter.com/excel-programming/297303-list-odbc-source.html)

matis

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

onedaywhen

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

--

Grant Reid

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

All times are GMT +1. The time now is 10:24 PM.