CopyObject Method Example
The following example uses the CopyObject method to copy the Employees table and give it a new name in the current database:
DoCmd.CopyObject, "Employees Copy", acTable, "Employees"