Tom’s Tutorials For Excel: Importing an Access database table into Excel — a Quick Shortcut

Tom’s Tutorials For Excel: Importing an Access database table into Excel — a Quick Shortcut

Here’s a shortcut to manually import an Access database table into your spreadsheet. It’ll come with the alternating shaded rows and field header drop-down arrows, but it’s fast and easy. The first picture shows an access table just for example, noting that in actual practice, the database file will be closed during this quick task that involves no programming code.

Step 1

Step 2

Step 3

Step 4

Your import is complete.