New DB Query - Relative Path

  • Thread starter Thread starter kaiser
  • Start date Start date
K

kaiser

Does anyone know of an easy way to manage the relative path link to a
external database for excel? I have a spreadsheet where I've importe
about 50 Access DB Queries. My problem is that if I copy the Access D
into a different folder or network folder the "link" is broken as Exce
cannot locate the DB any longer. I know that I can individuall
recreate these 50 DB Queries but this is a hassle. I'm sure there'
got to be a way internally to Excel that I can access to easily chang
this relative path.

Thanks
 
If it is only one file you can easily use Edit/Links and update the source
file.

HTH

PC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

relative path in OLEDB string 3
Relative path to linked excel sheets 1
Need help using a relative path in VBA 0
Use relative address for database query 3
Access Query criteria based on other field of the same query 0
Query Property: Source Database 1
Saving from clipboard into file from ms access 0
Linking Access Query to Excel make DB Read Only 1

Back
Top