in.dataTypes Argument

The in.dataTypes argument specifies how DbTransfer should read values from the excel file.

Format

/in.dataTypes:DataTypes

Example

/in.dataTypes:Text

Required

This argument is optional. If not specified the mode "Text" is used.

Possible values

Text or Native

Native

DbTransfer will interpret values as their native excel data types in excel files.

For example decimals are always interpreted as numbers and texts will always be interpreted as texts even if they contain numbers.

Text

DbTransfer expects all values in the excel file to be stored as texts.

For example decimals are not stored as numbers in the excel file but as a text.

DbTransfer will then automatically convert the values stored as text to the actual data types used in the destination (according to the settings specified in the Data Format section).

You must use this option if you want to import an excel file that you have previously exported with DbTransfer where you also choose this mode for the export.