You can export a table, query, form, report, macro, or module from one Access database to another. When you export an object, Access creates a copy of the object in the destination database.
To copy and paste data, follow these steps: Open Microsoft Access and navigate to the table or form containing the data you want to copy. Select the data you want to copy by clicking and dragging the cursor over the desired information. You can also use the "Ctrl" key to select multiple items.
First, select the data you want to copy. Press Ctrl-C, click the Copy button, or choose Edit>>Copy from the menu. Move the cursor to where you want to copy the data. Press Ctrl-V, click the Paste button, or choose Edit>>Paste from the menu. The data will be copied to the new location.
I have a number of Linked (ODBC) tables in my MSAccess DB. I what I want to do is create a copy of each table (preferably the Structure Only). ive tried, DoCmd.CopyObject , "NewTableName", acTab...
Since it is connecting to files, I could easily create backup Access files and transfer tables to them. And working with multiple files in multiple tables is much easier with OLE vs DAO, so I think I’ll use that technique.
Use the CopyObject action to copy the specified database object to a different Access database or to the same database or Access project (.adp) under a new name. For example, you can copy or back up an existing object in another database or quickly create a similar object with a few changes.
During the import operation, you can choose the objects you want to copy, control how tables and queries are imported, specify whether relationships between tables should be imported, and so on.
How to Copy Tables in MS Access - Office 365. This video explains how you can copy a table from MS Access database.