| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I add a table from a different DB to excel Query 2002?
CJ,
I agree with K Dales, MSQuery will not really help there. Succesfully combining data from different databases within a query depends on the actual driver used. For e.g. the Jet engine (which is used for everything from excel/access/dbase and more) the following trick works: SELECT tblAddresses.* FROM tblPeople INNER JOIN [C:\Data.mdb].tblAddresses ON tblPeople.PersonID = tblAddresses.PersonID I would advise experimenting with drivers and synatx to see if you can get it working for dbase/foxpro files. Dm Unseen |
| 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 | |||
Threaded Mode
