Copying from one table to another

[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

 

[Lynn Trapp]

Create the following Query

INSERT INTO YourFirstTable
SELECT * FROM YourSecondTable;

 

[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 *?

 

[Lynn Trapp]

Open a new Query in Design View
Select View > SQL View
Copy and paste the code I gave you below replacing the table names with your
actual table names.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm