How to import Excel data range into MS Access table using VBA

This quick tutorial will show you how to import MS Excel worksheet into MS Access using VBA. On this tutorial, we will only import some data specified by data range from Excel. The method that I use here is DoCmd.TransferSpreadsheet. See how it works below:

First, the following information from the Excel spreadsheet we want to import. Change it with your own details

Excel file name and location: “E:\test.xls”
Sheet name on the Excel file: Report1

[codesyntax lang=”vb”]

[/codesyntax]

Done.

Ariel

Leave a Reply

Your email address will not be published. Required fields are marked *