Need to take from one table in insert into another table

  • Thread starter Thread starter Rick Dunmire
  • Start date Start date
R

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
 
Create an append query to the new database without the autonumber field.
The new table will fill this in automatically.

Kelvin
 
Thanks Kelvin
That was what I needed
Rick
Kelvin Lu said:
Create an append query to the new database without the autonumber field.
The new table will fill this in automatically.

Kelvin
Click to expand...
 
Back
Top