Copying data to a new table

  • Thread starter Charles Phillips
  • 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???
 
J

Jeff Boyce

Charles

If both tables already exist, you could use either an append query or an
update query, depending on which fits your situation.
 
R

Ron Weiner

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
 
Top