[ WAA Home | AcceX Home | Download AcceX | Help using AcceX | AcceX FAQ | About WAA]
<< Listing Access database details in Excel
Importing MS Access tables into Excel
This option is used to import one or all of the tables contained in a MS Access database file, as with the listing option we are asked to select the database file to open
And then the Import dialog appears with four basic options.
We can either import all the tables (and all the data) or we can select a specific table from those in the file to import (the 'Name Table' in the the example above). We can also import any Queries that are in the database file.
All the records in the table are written to the Excel worksheet 'Name Table'. If all the tables had been imported there would be a sheet for each table.