merging two access database

[Guest_imported]

does anyone know how to merge two access database into one?

i have tha main database called cb200.. and i have anotherone cb199 and i want to merge cb199 to cb200...

how can i do that?
thank you

 

[THoey]

Are they structured the same? If so, just write an append query like:

INSERT INTO cb200
SELECT * FROM cb199;

Like I said, this will only work IF your tables are structured the same (same field names). If not, you will have to specifically select the fields to import and import into.


Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?

 

[TheInsider]

Hi,
Do what Terry suggested but include the "IN" clause in your SQL statement to access external tables. Also, watch out for duplicate value violations among indexed or primary key fields... combining databases can get tricky. I've created many applications for different databases to do this, so I have tons of experience here - many different ways to go about it.

Rob Marriott
rob@career-connections.net