Re: Multiple databases

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "John Spencer" <spencer@xxxxxxxxx>
Date: Fri, 30 Nov 2007 12:35:09 -0500

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
..

"Double D" <rwd@xxxxxxxxxx> wrote in message
news:8835ca7b-255e-4765-a782-a2a9aa2060b5@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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.

References:
- Multiple databases
  - From: Double D

Prev by Date: Re: findfirst date leading zero
Next by Date: Re: Query Problem
Previous by thread: Multiple databases
Next by thread: Calendar problem selecting last day of month
Index(es):
- Date
- Thread

Relevant Pages

Re: MERGE 2 DB
... Access is a Database ... MS Access MVP ... "Duane Hookom" wrote: ... union query to combine the tables into a single record set. ...
(microsoft.public.access.queries)
Re: Reference Libraries
... John Spencer ... Access MVP 2002-2005, 2007-2008 ... Center for Health Program Development and Management ... You can develop your functions in any database and then copy and paste ...
(microsoft.public.access.modulesdaovba)
Re: Main Menu Form Will Not Open
... fEnable As Boolean) As Boolean ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ... What is the name of the form that should open when the database opens? ...
(microsoft.public.access.forms)
Re: Time a query
... Access MVP 2002-2005, 2007-2008 ... John Spencer wrote: ... You add a table to your database name named QueryResults with 4 fields: ... Dim dbAny As DAO.Database ...
(microsoft.public.access.queries)
Re: Time a query
... "John Spencer" wrote: ... Access MVP 2002-2005, 2007-2008 ... You add a table to your database name named QueryResults with 4 fields: ... Dim dbAny As DAO.Database ...
(microsoft.public.access.queries)