Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Editing queries in Excel

Status
Not open for further replies.

tempclerk

Technical User
Jun 26, 2001
292
US
I set up a query (in Excel) to import data from Access to Excel, and then moved the database to a different directory. Is there a way to update the query with the new path, or do I have to do a whole new query?
 
Is it linked? You should be able to do a find/replace. For instance:

Find
c:\foldername\filename

Replace with
j:\foldername\filename

Make sure the syntax is exactly as it currently appears in your file.

Make sure "entire cell" isn't checked. Hit replace all.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top