Multiple databases

[Double D]

I have 10 databases that have the exact same layout (employee time).
What is the easiest way to combine the information into one new file.
I have tried JOIN and UNION and either don't really understand how
they work or used them incorrectly.

 

[John Spencer]

Do you have ten databases? or do you have ten Tables in one database?

If the former, I would suggest a new database with links to the relevant
tables in each of the databases and then you could build a union query based
on the linked tables. If you want all the data in one database then you
would need to build the employeeTime table and then run Append queries to
add the records from each of the ten tables to the newly created table.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[pietlinden]

One potential problem with union queries is that they are *not*
updateable. If you want a read-only result, then using a union query
is a good idea... if not, you need to append everything to a single
table.