Access - Import an Excel table

December 2016




Issue


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

Solution


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.

Related :

This document entitled « Access - Import an Excel table » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.