Copying A Table 1

[chendes]

Using SQL what is the quickest way of copying a table

 

[jrbarnett]

If you mean you want to duplicate a table and its contents, try

select *
into newtable
from table

then you need some VBA code to set up primary and foreign keys and referential integrity.

John

 

[chendes]

Thats fantastic. Is it possible to do a select into an exsisting table as apposed to create a new table?

 

[jrbarnett]

Yes:

Insert Into Tablename (Field1, Field2, Field3)
Select Field4, Field5, Field6 From Oldtablename

Remember that the primary key restrictions will be enforced, and you can restrict the records that can be copied using a Where clause on the select.

John