The Import/Export Wizard provides default values. Although other parameters may be available through the ODBC Administrator, UPS recommends that you use the parameters below.
Note: All versions of Microsoft Excel use the *.xls file extension.
|
Attribute Name |
Basic/ |
Optional/ |
Default |
|
DBQ |
Basic |
Required |
The same option as Database in the Set Up window. |
|
Description |
Basic |
Optional |
The same option as Description in the Set Up window. |
|
FIL |
Basic |
Required |
File type: .XLS .XLSX .XLSM .XLSB |
|
PAMAXSCANROWS |
Advanced |
Required |
8 |
The number of rows to be scanned when setting a column's data type based on existing data. |
READONLY |
Advanced |
Required |
TRUE |
TRUE to make file read-only. |