Changing Data Links

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have several Excel files that use External Data Links to an Access
Database. The location of the Access Database has been changed to a new
folder. Is there a way in Excel to change the link location (address)
without having to delete and rebuild the links? Somplace where I can type in
the new location for the source data?
 
I would think you can do it from either the Data - Edit Query menu, or Edit -
Links menu.
 
Back
Top