Hi
I want to replicate the structure of the tables accessThere is a command for create script "create table..." from the table access.
Thank you in advance
Corti
Hi
I want to replicate the structure of the tables accessThere is a command for create script "create table..." from the table access.
Thank you in advance
Corti
Let me see if I understand you correctly. You want to use VBA Code to make a copy of an entire Table, right?
If that's correct, then all you need to do is the following:
Code:DoCMD.CopyObject, "CopyTableName", acTable, "OrigTableName"