Copying data to a new table

  • Thread starter Thread starter Charles Phillips
  • Start date Start date
C

Charles Phillips

Hello,
I an cleaning up an MS-Access 2000 database.
I want to copy certain data from one table to another.
How do I go about doing this???
 
Charles

If both tables already exist, you could use either an append query or an
update query, depending on which fits your situation.
 
If you want to create a new table on the fly, you can use a make table
query. Might look like:

SELECT * INTO tblNewTable FROM tblOldTable

To copy the entire contents of tblOldTable into a new table that it creates
on the fly tblNewTable. If you want to duplicate the table structure
without inserting any records:

SELECT * INTO tblNewTable FROM tblOldTable WHERE 1 = 2

Ron W
 
Back
Top