Save a Table Under New Table Name

[jdoverton]

Hey,

I need to save a table under a New Table Name while in Access VBA.

I need to conserve the properties and Column names from one table to the new table.

Any suggestions?

Thanks much,
John Overton

[MMcCarthy]

Hey,

I need to save a table under a New Table Name while in Access VBA.

I need to conserve the properties and Column names from one table to the new table.

Any suggestions?

Thanks much,
John Overton

Have a look at a Make Table Query

Create Table Statement
SELECT Column1, Column2 INTO NewTable
FROM OldTable;