Does insert into table from table work in base

[DaveDuncan1]

I have a single table database that I want to split into multiple tables. I tried the following;

INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1;

Doesn’t work. where can I find a list of sql commands that work in base?

[peterwt]

The syntax is wrong.

This works for me.

INSERT INTO "Table9" ("New") SELECT "Name" FROM "Table1"

You need " around Table and Column Names. The Table you are inserting into must exist and also the Column.

So in my example Table9 exists with a blank Column New.