list ODBC source

[matis]

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]

several excel file attached to an mdb database.

How are they 'attached'? Linked tables in Jet? MS Query in Excel? ..?

--

 

[Grant Reid]

Hi

I found a web site that might answer your question.

http://www.dicks-clicks.com/excel/ExternalData.htm

Hope this helps, Regards - Grant