If you’ve been collecting data in other places—perhaps in a text file or an Excel spreadsheet—you can easily import your data into Access 2013 so that you don’t have to type it all again. You use the External Data tab to bring that information into your desktop database.
Click the External Data tab.
In the Import & Link group, click Access.
The Get External Database dialog box opens.
Click the Browse button. In the File Open dialog box, navigate to the file that you want to open, click it, and then select Open. The file name is added to the Get External Data dialog box.
Leave the Import Tables option selected.
The Import Objects dialog box opens.
Click Select All. Alternatively, select the name of ...