Thread: Database query
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default 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