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.