NeoDBpro - Copy and rename Table

#1 · September 29, 2025, 12:47 pm

I'm trying to copy a table from an Access database and rename it.

dbpExecSQL "Mydatabase" "CREATE TABLE [TableName] AS; SELECT * ; FROM Cust_1;" ""

The code above will create the table but without any Fields, so making the table useless for adding records.

Can anyone help and explain where i'm going wrong please.

#2 · September 29, 2025, 6:42 pm

@m-burdess try this:

dbpExecSQL "Mydatabase" "SELECT * INTO TableName FROM Cust_1;" ""

Regards.

alangonzalez91 has reacted to this post.

#3 · September 29, 2025, 10:56 pm

Thank you, this has worked. Looks like I was over thinking it.

Regards.

NeoDBpro - Copy and rename Table - Forum