Copying from one table to another

  • Thread starter Thread starter castor
  • Start date Start date
C

castor

Hi,

I have two tables in my Access db with the exact same
structure. I just want to copy all the records from one of
them to another. In other words consolidate the records
into ine database. Is there a way to do this faster than
just simple copying all the records and pasting in the
other. The numbe rof records is huge so that will take for
ever.

Please let me know.

Thanks - Castor
 
Sorry, but I am new to Access. Can you please explain in a
little more detail how would I do this i.e. Insert and
select *?
 
Back
Top