When importing MS Access data into a new table, you will be presented with the following dialog to configure the available options:
NOTE:
The Microsoft Access Database Engine 2010 Redistributable must be installed on the computer to import .accdb files.
After selecting the sheet that you want from the Available Tables drop-down list, you can alter the field name, data type, and size by selecting the field from the list of Available Fields, typing in the new Field Name in the space provided, selecting the data type from the Field Type drop-down list, typing in the desired size in the Field Size box, and pressing the Apply Field Changes button.
You can also choose which fields are imported by checking or un-checking the box next to the field name.
You will need to follow the aforementioned steps for each field that you wish to configure.
