Copy structure of existing table to a new table

[DavidWrightSr]

I am trying to automate a sequence of events which starts with the creation of a new table from an existing table, leaving the existing table undisturbed so as to be able to repeat the sequence later from the same beginning point.

I have tried using various commands similar to
CREATE TABLE new_table_name AS
SELECT column1, column2,...
FROM existing_table_name

but they all give me a syntax error when I try to save it.

I suspect that these fail because this form of SQL doesn't work in access.

I am planning on completing the sequence using either a series of macros or a VBA procedure. I have already created the necessary SQL commands to complete the sequence, but I am currently having to do all of the individual commands manually.
I would like to be able to execute the entire sequence by clicking on a single button.

Any help would be appreciated.



the structure of the file is as follows:

[ranman256]

Right click the table,paste as table_MT. Use this as the source.
then when you need a copy, in a macro run CopyObject.