Combining 2 MS-Access Databases

[Matt in BrisVegas Australia]

Hi everyone,

I have a query regarding a task I have been assigned at work. It seems quite
simple at first sight - There are two databases with VERY similar table
structure, queries etc which we wish to *combine* into one large database.

Naturally I tried a simple File - Get external data - Import and selected
the other database. The problem there is that it creates dual copies of each
table that appears in both databases (ie. I now have a table called "Users"
and a table called "Users1").

Any advice on how to avoid this and to just combine all data within the two
tables into one single table when I do the import?

Thanks in advance,

Matt

 

[John Nurick]

Hi Matt,

Make certain you have backups of everything.

Then set up linked tables (File|Get External Data|Link) in one database
connected to the other, and use append queries to move the data from the
linked tables into the "real tables".

 

[Matt in BrisVegas Australia]

Cheers John,

I will have a go at this one today. It sounds simple enough for me to be
able to follow through

Thanks for the advice