Change Excel to Access Database Link

External Since: Jun 20, 2006 Posts: 2

We have several Excel spreadsheets with links to Access Databases. He have
move the databases & need to change the links to the new location. But, I
can't find where to do this. I looked under "Edit" and see "Links" there,
but it is greyed-out and not available to me. How can I re-map the links.
Thank you.

External Since: Jul 30, 2004 Posts: 669

The "links" are probably actually QueryTables (ie the result of
Data > Import External Data > New Database Query )

To change the location of the source file you would need to change the
Connection property of the QueryTable (and possibly also its SQL or
Command property).

If you need to change multiple workbooks I can offer you a free
LinkManager utility that will do it for you.

Email me at Bill_Manville at compuserve dot com to request a copy.

Bill Manville
MVP - Microsoft Excel, Oxford, England