combine 2 database

[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

 

[Pat Hartman]

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.

 

[John W. Vinson]

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

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]

 

[Hanamachi]

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

thanks

 

[John W. Vinson]

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

thanks

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]

 

[Hanamachi]

there are no autonumber fields.

thanks for the help so far

 

[Hanamachi]

the common fields are
name
hits
surftime
date

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

 

[Hanamachi]

i think I just figure it out,

thank you SO MUCH

you been very helpful