Datatype Conversion for Express Transfer Statements

Acceptable source datatypes that the access service can convert into corresponding target destination datatypes.

If a column match is incompatible, the transfer ends with an error. If data conversion errors occur, you should try swapping the connections to the drivers used for the primary server and the secondary server.

Note: The datatype conversions identified may not be available for express transfer. Availability varies depending on the ODBC driver that is used.

Datatype Conversions
Source Datatypes	Target Datatypes
Source Datatypes	`CHAR` `VARCHAR` `LONGVARCHAR` `TEXT (CLOB)`	`BIGINT` `DECIMAL` `DOUBLE FLOAT` `INTEGER` `MONEY` `MONEY4` `NUMERIC` `SMALLINT` `REAL` `TINYINT`	`DATETIME` `DATETIME4` `TIMESTAMP`	`BINARY` `VARBINARY` `LONGVARBINARY` `IMAGE (BLOB)`	`BIT`
`CHAR` `VARCHAR` `LONGVARCHAR` `TEXT (CLOB)`	x	x	x	x	x
`BIGINT` `DECIMAL` `DOUBLE` `FLOAT` `INTEGER` `MONEY` `MONEY4` `NUMERIC` `REAL` `SMALLINT` `TINYINT`	x	x
`BINARY` `VARBINARY` `IMAGE (BLOB)` `LONGVARBINARY`	x			x
`DATETIME` `DATETIME4` `TIMESTAMP`	x		x
`BIT`	x	x			x