ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change the path of a Microsoft Query? (https://www.excelbanter.com/excel-programming/351260-change-path-microsoft-query.html)

MWH

Change the path of a Microsoft Query?
 
I'm working with a spreadsheet that uses a query, the query looks at an
Access Database. I have changed the physical location of the database and
would like to change the query path. Is there a way to do this without
making a new query?


--
Mark W. Hanford




Tom Ogilvy

Change the path of a Microsoft Query?
 
If your talking about a querytable, you should able to right click in the
data area and edit the query.

--
Regards,
Tom Ogilvy

"MWH" wrote in message
.. .
I'm working with a spreadsheet that uses a query, the query looks at an
Access Database. I have changed the physical location of the database and
would like to change the query path. Is there a way to do this without
making a new query?


--
Mark W. Hanford







All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com