Question: how to export data from one access database to another?
Answer: On the External Data tab, in the Export group, click Access. ... 
Access opens the Export - Access Database dialog box.
In the File name box on the Export - Access Database dialog box, specify the name of the destination database and then click OK.