Is it Possible to merge Databases of the same type into one?

[michaeldh]

Hi Guy's,

I was hoping you might have the answer to merging access databases into one file.

I have separate files for July August September etc etc and would like to get them all together in one database....any ideas??

The data has the same layout / fields in all separate data tables.

Thanks.

Michael.

 

[Parra]

Re: Is it Possible to merge Databases of the same type into

Import or link the tables into 1 common database. Create a Append query to merge all the tables into 1.

Hope this helps.

Parra

 

[Russell Hauf]

Re: Is it Possible to merge Databases of the same type into

Try a UNION query. This must be done in SQL view (when your query is in design view, go to View-SQL View). Something like:

SELECT * FROM JUN
UNION ALL SELECT * FROM JUL
UNION ALL SELECT * FROM AUG;

The UNION ALL will make sure that you get all records from all tables, even if there are what appear to be duplicate records.

HTH,

Russell