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.

Share Button
Posted in Tom's Tutorials for Excel
Tags: ,

Leave a Reply

Your email address will not be published.

*