01 – Excel Importing – Introduction

The ability to import data from Excel is a very useful feature of the Office suite. Access has its own in-built importing capabilities but sometimes these are not enough and we require VBA to give us more control over the process.

In this series of posts we will be taking you through the basics of importing from Excel. We will show you how to prepare an Excel sheet correctly for importing and how to use the native Access functionality to perform the import.

We also take a look at the Excel object model and show you how you can . . .

In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.


In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!