View Single Post
 
Old 07-30-2015, 11:57 PM
jaworski_m jaworski_m is offline Windows 2K Office 2000
Novice
 
Join Date: Nov 2011
Posts: 2
jaworski_m is on a distinguished road
Default 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
Reply With Quote