Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002, MS Query and MSSQL View with periods | Excel Discussion (Misc queries) | |||
Microsoft Query is lost when opening Excel 2002 file | Excel Discussion (Misc queries) | |||
Specifying table in Excel 2002 web queries | Excel Discussion (Misc queries) | |||
Web Query Doesn't Return All Tables With Excel 2002 | Excel Programming | |||
Linking a table in Access to a table in Excel using MS Query | Excel Programming |