Update data connection - path, database name, query definition
Hello,
I have an Excel file with ~10 connections to MS Access (tables, queries).
Is there a smarter way to update information about these connections than manually deleting and then reconnecting them with Excel in case:
- Database location changes
- Database name changes
- Query definition inside DB changes (for ex.a field is added or removed)
Manual operation is tedious and time consuming.
Any hints will be appreciated.
Marcin
|