How to Import an Excel Spreadsheet Into Access With a Macro

Written by bonnie conrad
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Import an Excel Spreadsheet Into Access With a Macro
Creating a macro can save you time. (computer a3 green dots image by patrimonio designs from

One of the most useful features of Microsoft Access for business users is its ability to integrate with other types of files. Microsoft Access can accept files in a wide variety of formats, including Excel spreadsheets, text files and mainframe documents. Users can make it even easier to import those files by setting up a macro that will do the work automatically. Once the macro is created, all the end user has to do is press a few buttons to import the data from the specified Excel spreadsheet.

Skill level:


  1. 1

    Log on to your computer and open the Microsoft Access database. Click on the "Macros" tab.

  2. 2

    Click "New" to create a new macro. Click the drop-down box under "Action" and choose the "Transfer Spreadsheet" option.

  3. 3

    Change the transfer type to "Import" and type the file name, including the full path. For instance, if your spreadsheet is on your C drive in the spreadsheets folder, you would need to type "C:\Spreadsheets\MySpreadsheet.xls."

  4. 4

    Click "Yes" or "No" in the "Has Field Names" box. Choose "Yes" if the first row in the spreadsheet contains the field names, otherwise click "No."

  5. 5

    Click on the red X in the upper right-hand corner of the screen and answer "Yes" when prompted to save the macro. Give the macro a descriptive name.

  6. 6

    Go to the "Macros" tab and double-click the macro to run it and import the spreadsheet. You can also right-click the macro and choose "Run" from the menu.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.