Combining Databases

[Avslavedriver]

I have two databases containing the same fields, is there anyway to combine them into 1 so i can query them together. - Thanks

 

[Joe4]

Yes, you can do a UNION query to combine them.

In order to do this, take the SQL from each query, and simply connect them with the UNION command, i.e.

SELECT ...
UNION
SELECT ...

Access Help also has a few simple examples of UNION queries.

 

[Avslavedriver]

i know that works for 2 Tables, but how can i do two totally different databases, or maybe thats what you mean.

Please show an example

 

[Joe4]

Have you tried importing the data from the Table in one database to the corresponding Table in the other database? Then repeat for all Tables.

 

[bat17]

or just create linking tables if you want to keep the bases seperate for some reason

you can then do your Unions on the links

Peter