Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-30-2015, 11:57 PM
jaworski_m jaworski_m is offline Update data connection - path, database name, query definition Windows 2K Update data connection - path, database name, query definition Office 2000
Novice
Update data connection - path, database name, query definition
 
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
  #2  
Old 08-03-2015, 02:37 AM
thetraininglady thetraininglady is offline Update data connection - path, database name, query definition Windows 7 64bit Update data connection - path, database name, query definition Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

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

Tags
data connection



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
Update data connection - path, database name, query definition get access database path in Word vba marooned Word VBA 2 07-04-2012 06:37 AM
Update data connection - path, database name, query definition How do I dynamically update data in a Word Document from a database table RSchmidt Word 1 07-14-2011 04:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft