How to Import Microsoft Access Data into Excel?

Access is the primary MS Office app that allows you to make and arrange a database. This easy to use app can be used for making business apps using templates from scratch. It is good for organization, storage, and retrieval. At times, you may want to import Access data into Excel. Follow the instructions mentioned below to learn how to export data from an Access database to an Excel spreadsheet.

Import Microsoft Access Data into Excel

  1. Launch the MS Excel worksheet on your system.
  2. Then move to the tab of Data at the top.
  3. You should select the pull-down of ‘Get Data’ and then click on Get & Transform Data.
  4. Later, click on  Microsoft Access Database.
  5. Now, find the file of Access and click on it.
  6. Then tap on the Import button.
  7. Click on the table inside the left panel of the screen of Navigator.
  8. Thereafter, tap the button of Load.

Import MS Excel Data into Existing Access Table

  1. Ensure that the Excel spreadsheet has similar headers as present in the Access database.
  2. You should launch the database of Access.
  3. Then select the option of Enable Content in case a security alert appears.
  4. Later, move to the tab of External Data.
  5. You have to choose the Excel option.
  6. Once the ‘Get External Data – Excel Spreadsheet’ prompt appears, search for the Excel file.
  7. After that, choose the ‘Append a copy of records to the table’ option.
  8. Go to the appropriate table inside the pull-down, and tap the OK button.
  9. Now, choose the worksheet you would like to import and tap on the OK button.
  10. Finally, press the Finish button.

Import MS Excel Data into a Fresh Table in Microsoft Access

  1. First, open the database of Access.
  2. Then select the option of Enable Content if a security alert appears.
  3. After that, move to the tab of External Data and select the Excel option through.
  4. In the ‘Get External Data – Excel Spreadsheet’ window, find the Excel file.
  5. You have to choose the ‘Import the source data into a new table in the current database’ option.
  6. Then click on the OK button.
  7. In case the first row over the Excel worksheet includes headers, tick the “First ‘Row Contains Column Headings’ box.
  8. Now, hit the Next button.
  9. You can tweak the columns.
  10. Afterward, select the Next button.
  11. You should enable ‘Let Access add primary key’, and click on the Next button.
  12. Finally, press the Finish button.

Emily Johnson is a creative person who has been writing blogs and articles about cybersecurity. He writes about the latest updates regarding mcafee.com/activate and how it can improve the work experience of users. His articles have been published in many popular e-magazines, blogs, and websites.