The 'export from Excel' option is used to convert a selected Excel sheet in the active workbook to an MS Access database file. Each column is written as a field and each row as a record.
The user also has the option to use the first row of the sheet as the names for the fields in Access. For each field written by AcceX the user must define what type of data (eg. text, integer, etc) is to be stored in that field.
Lets take the simple worksheet show below:
To convert it to a Access database file we select the 'Export' option from the AcceX menu
This brings up the dialog where we can select the sheet to import and also set whether to use the first row of the sheet as the field labels.
If we change the sheet name in the pulldown list then the selected sheet becomes active.
For this example the first row does contain the field names to be used in the database file so lets select that option.
If this option was not selected the first row of the worksheet would be treated as data and the fields would be labelled Field1, Field2, ...
On clicking the OK button we are asked for a name for the database file, which is by default the sheet name we are converting and then, for each column we are importing we need to specify the type of data to be stored.
For the first three fields in the example we want to import as text, but the DoB column is a date so we select that data format from the available list.
The last column, the stall number is an integer so again we select that type from the list.
We have now generated an Access database file from the Excel sheet.
