Create a copy of existing table

if you to create a copy of a existing table in access database.

Here is the code-

Sub create_copy_of_existing_table()
DoCmd.SetWarnings (False)
DoCmd.RunSQL "SELECT * INTO copy_staff_detail FROM sales_detail "
DoCmd.SetWarnings (True)
End Sub


Download Access Database