An Access database file contains one or more tables, each of these tables contains a number of fields (for example we might have a table containing network user details, their username could be one field, their first name another and their last name a third) and a number of records with the data in. An record example for our user database might be:
| User Table | |||
| Field1 Username |
Field2 First name |
Field3 Last name |
|
| Record1 | Biggles | John | Smith |
| Record2 | Possum | Julie | Drew |
| Record ... | ... | ... | ... |
Discovering what data is contained within an Access file can be difficult, AcceX can help. This first option lists all tables contained in the database file and the field names for each of those tables.
Having selected the option from the menubar, AcceX asks for the name of th database file to be examined:
On opening the file, AcceX overwrites the current Excel worksheet with the table and field details of the database.
In the example above, there were seven tables in the database (although the ones being MSys we do not have to bother with), we have two tables ('Name Table' and 'Machine details'), the names of the four fields in the Name table are listed along with the six in the Machine details table.
Importing the data into Excel >>