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 control an Excel application from MS Access.
So dive in!
