combine 2 database

  • Thread starter Thread starter Hanamachi
  • Start date Start date
H

Hanamachi

Hello everyone,

I want to combine 2 database files I imported into a new database.

How can it be done?

I opened a new database and imported 4 database files, now how do I combine
all 4 into one?

thanks
 
Assuming that they are the same format, decide which one will end up as the
master and then create three append queries. One for each table you want to
append to the master.
 
Hello everyone,

I want to combine 2 database files I imported into a new database.

How can it be done?

I opened a new database and imported 4 database files, now how do I combine
all 4 into one?

thanks
Click to expand...

Do you want to combine two *databases* - .mdb files containing multiple
tables, forms, reports, and other objects?

Or do you want to combine two *tables* within a database file?

If two tables, are they of identical structure (with the same number of fields
of matching datatypes), or are they different in structure?

Again if two tables, do the two tables have Autonumber primary keys - and if
so are there records in the two tables with different data but the same
primary key value?

John W. Vinson [MVP]
 
it's a couple of tables in the same .mdb file I want to combine into one
all have same fields.

thanks
 
it's a couple of tables in the same .mdb file I want to combine into one
all have same fields.

thanks
Click to expand...

Then - with the exception of the case where there are clashing Autonumber
fields in the two tables, which you did not answer - you can create an Append
query and append all the records from one table into the other table. Back up
your database first just in case you find that this causes problems!

John W. Vinson [MVP]
 
the common fields are
name
hits
surftime
date

now how do i append
i did it and it gave me invalid argument
 
Back
Top