Query using three DB

[ldiaz]

hello all

I have three data Bases named:
SCDB-2005
SCDB-2006
SCDB-2007 (Current used to enter datas)

the three DB has a query named:
AUTOMOTIVE MAIN Query wich it contain the same columns
I have three excel reports that are connected to these but the problem is
because one user is asking me to have a unique query with all information
from SCDB-2005 to SCDB-2007, could you please help me on this,


Note:
SCDB-2007 is the current DB were Produccion is entering datas

 

[Franck]

the best way seems to link tables from old database to the new one and
query everything in 1 shot selecting on multiple tables.

 

[Pieter Wijnen]

One of the many problems with splitting data
but
in the Frontend create a query similar to this:

SELECT A.* FROM MyTable A IN 'C:\Data\SCDB-2005.mdb'
UNION ALL
SELECT A.* FROM MyTable A IN 'C:\Data\SCDB-2006.mdb'
UNION ALL
SELECT A.* FROM MyTable A IN 'C:\Data\SCDB-2007.mdb'

And use this as the source for Excel

HTH

Pieter

 

[ldiaz]

Thank you So much, this Work perfectly
--
Lorenzo Díaz
Cad Technician

One of the many problems with splitting data
but
in the Frontend create a query similar to this:

SELECT A.* FROM MyTable A IN 'C:\Data\SCDB-2005.mdb'
UNION ALL
SELECT A.* FROM MyTable A IN 'C:\Data\SCDB-2006.mdb'
UNION ALL
SELECT A.* FROM MyTable A IN 'C:\Data\SCDB-2007.mdb'

And use this as the source for Excel

HTH

Pieter