Update data connection - path, database name, query definition

		Microsoft Office Forums > Microsoft Excel > Excel
Update data connection - path, database name, query definition

FAQ

Thread Tools

Display Modes

07-30-2015, 11:57 PM

jaworski_m jaworski_m is offline

Windows 2K Update data connection - path, database name, query definition

Office 2000

Novice

Join Date: Nov 2011

Posts: 2

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

Tags

data connection

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:43 PM.