Question: how to copy and paste data from one access database to another?
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.