Update data connection

jaworski_m · #1 07-30-2015, 11:57 PM

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

thetraininglady · #2 08-03-2015, 02:37 AM

Is upgrading an option because newer versions of Excel have a Refresh All option relating to External data connections.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Update database	Sandhya	Excel	1	03-04-2015 07:55 AM
How do I permanently update the file name path in the Data Link properties?	lynnwalder	Mail Merge	2	05-20-2013 11:38 AM
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel?	mag	Excel	0	10-18-2012 11:15 AM
get access database path in Word vba	marooned	Word VBA	2	07-04-2012 06:37 AM
How do I dynamically update data in a Word Document from a database table	RSchmidt	Word	1	07-14-2011 04:27 PM