Access - Import an Excel table

April 2018


I have several tables in one Excel sheet. Can I import just one of them in my Access database?


Yes, if the cell ranges in Excel tables are named. Access will then offer a selective import options.
  • To name a cell range in Excel, first select the table. Then go through the menu INSERT / NAME / DEFINE ... In the dialog box, enter a name for your table. Click Add and then OK to confirm.
  • Remember to save the workbook and start the import from Access.
Published by aakai1056. Latest update on May 8, 2012 at 10:04 AM by aakai1056.
This document, titled "Access - Import an Excel table," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (
Access - Add check boxes to forms
Access - Group multiple items under a single query