ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Database query (https://www.excelbanter.com/excel-discussion-misc-queries/141262-database-query.html)

Jeff

Database query
 
Hi,

I am reposting this because my last post did not have enough info - sorry.

I have a database query saved in a worksheet. It is looking at a foxpro
database. So I am choose "Data -- import external data -- new database
query -- foxpro database -- then I just paste the path where the query
looks, highlight the file and add the fields that I am interested in" to
create the query.

I have a bunch of these in my worksheet - and every so often I need to
change to path to the query because I want to look at a different foxpro
database in a different location. Does anyone know how to change the path or
check the
path to the query. I can not figure out which database the query is looking
up.

Thanks for your help



All times are GMT +1. The time now is 07:36 AM.

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