Question: how to copy data from one table to another in ms access?
Answer: Right-click the existing table name in the Database Window of the original database and click Copy.
Close the database Window and open your new database.
Under Objects, click Tables. Then, right-click the database Window and click Paste.
Enter a name for the new table, choose Structure Only, and then click OK.