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: