Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? jocke Excel Discussion (Misc queries) 1 November 29th 05 01:44 PM
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? jocke Excel Discussion (Misc queries) 0 November 28th 05 06:37 PM
Anyone Else Use Database Query to Query Another Sheet in the Same Ron Coderre Excel Discussion (Misc queries) 0 November 28th 05 06:16 PM
MS Query not installed for New Database Query Malcolm Walker Excel Discussion (Misc queries) 0 August 2nd 05 10:58 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"