![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
Is upgrading an option because newer versions of Excel have a Refresh All option relating to External data connections.
|
![]() |
Tags |
data connection |
|
![]() |
||||
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 |
![]() |
marooned | Word VBA | 2 | 07-04-2012 06:37 AM |
![]() |
RSchmidt | Word | 1 | 07-14-2011 04:27 PM |