How to Import Data From Access to Excel

You can import information into a database from other file formats, such as Excel, or from other Microsoft Access databases. You can quickly and easily import tables, forms, reports, queries, macros, and modules from one Access database into another Access database.

Import Access Objects

Instead of creating a new object (such as a form) from scratch, you can import an object from another database and then modify it as needed.

1. Click the External Data tab.
2. Click the Access button.
   

The Get External Data dialog box appears. Here you need to specify the Microsoft Access database that contains the object(s) you want to import into the current database.

3. Search for and double-click the database with the object(s) you want to import.
   
4. Click OK.
   

The Import Objects dialog box appears. Here you need to choose the type(s) of object(s) you want to import.

5. Click the tab that corresponds to the type of database object you want to import and click OK.
   
6. Click Close.
   

When you finish the Wizard, Access will ask if you want to save the import steps so you can repeat them in the future. If you want to, select the Save import steps option and click the Save Import button. To access the saved steps in the future, click the Saved Imports button in the Import & Link group.

You can also import database objects by opening the database containing the object you want to import, copying the object, and then pasting the object in the current database. Or, right-click a table object in the Navigation Pane of the current database, point to Import, and select the type of data source you want to use.

Import Excel Data

1. Click the Excel button on the External Data tab.

   You can also import data from sources such as SharePoint Lists, text files, XML files, or ODBC databases such as SQL Server. Just click the desired button in the Import & Link group.

   

The Get External Data dialog box appears. Here you need to specify the Microsoft Excel file that contains the data you want to import into the current database.

2. Search for and double-click the Excel file you want to import.
   

Now you need to choose from a couple options:

• Import the source data into a new table in the current database.
• Append a copy of the records to the table: [Table name].
3. Select an option for how you want to store the data in the current database and click OK.
   

The Import Spreadsheet Wizard dialog box appears.

4. Follow the onscreen instructions to finish importing the Excel data.
   

Once you've reached the end of the Import Spreadsheet Wizard, click Finish.

5. Click Close.
   

You can also create e-mails to gather information for your Access databases. Click the Create E-mail button in the Collect Data group and follow the Wizard's instructions. Later, click the Manage Replies button to view replies from recipients and update Access with the collected data.