list ODBC source

matis · May 5, 2004

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 · May 7, 2004

matis said:
several excel file attached to an mdb database.

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

--

Grant Reid · May 14, 2004

Hi

I found a web site that might answer your question.

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

Hope this helps, Regards - Grant

list ODBC source

matis

onedaywhen

Grant Reid