View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CJ CJ is offline
external usenet poster
 
Posts: 102
Default How can I add a table from a different DB to excel Query 2002?

Hi Folks! Spent much time looking for a solution. I need to add a table to an
existing excel query, but it is coming from a different database.

I have a foxpro database call it xx.dbf the table I need is not witihin the
same container, but it is related. Within my current query how can I add a
new table from another DB. I have a named a DSN for the other data source,
but cannot seem to find the correct syntax, or am I asking excel to do too
much.

Any words of wisdom would be greatly appreciated.

Thanks

CJ