The Set Field Properties dialog box allows you to specify the field (column) name and data types when importing Excel data. If you cancel this dialog box, the import process stops.
To access this dialog box:
- Open an Excel (.xls or .xlsx) file in MapInfo Pro. The Excel Information dialog box displays.
- Click OK to display the Set Field Properties dialog box.
Name
Use this field to indicate the name of the table field (column name).
Type
Use this field to indicate the data type of field that is selected. Available types include: Character, Integer, Small Integer, Float, Decimal, Date, or Logical.
Width
Use this field to specify the limit to the number of characters in the field. (This field displays when you select Character or Decimal data types only.)
Decimals
If you select the Decimal field type, use this field to indicate how many decimal entries are expected in this column.
See Also: