How to copy tables from one Access database to another 2009-03-13 It’s simple. Use the import function. Open the destination database. Right click in the table pane. Select Import. Choose the origination database. Choose the tables you want to import. Select to copy structure and/or data. Done. Jon