You can override the default data type assignment by assigning data types to individual Oracle columns.
Select an Access Table from the combo-box to display the data type settings for the current column.
The Oracle data type override is displayed in the Oracle Data Type column. When blank, the data type default setting is used.
Click the combo-box arrow to display the data type choices for the current column. Choose and entry from the list to override the default data type setting.
For Auto-Number columns, a pop-up form is displayed after selecting a combo-box entry, where additional Oracle Sequence information may be supplied.
To reinstate the default data type for a given column, clear its contents.