Need to take from one table in insert into another table

[Rick Dunmire]

Hello all

I have an existing database I am working with and all of the primary keys
are autonumbers.
I need to copy the information from a table in that database and insert it
into another database
with the same table. If I copy and paste the table I get relationship
problems and if I copy and
paste the data into the table I get a consecutive numbering of the
autonumber, problem is that
some of the rows have been deleted in the existing database so if I paste,
that primary key order
is messed up. So is there a query I can run to insert the information from
one table into another without
changing anything else. The present database is giving me problems with the
relationships but the new
database works properly I just need to put the old info into the new
database. Is this possible without
an act of congress?

Rick

 

[Kelvin Lu]

Create an append query to the new database without the autonumber field.
The new table will fill this in automatically.

Kelvin

 

[Rick Dunmire]

Thanks Kelvin
That was what I needed
Rick

Create an append query to the new database without the autonumber field.
The new table will fill this in automatically.

Kelvin