Table 9-2 shows the 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.
The datatype conversions identified in Table 9-2 may not be available
for express transfer. Availability varies depending on the ODBC
driver that is used.
Source datatypes |
Target datatypes |
||||
|---|---|---|---|---|---|
CHAR VARCHAR LONGVARCHAR TEXT (CLOB) |
BIGINT DECIMAL DOUBLE FLOAT INTEGER MONEY MONEY4 NUMERIC REAL SMALLINT 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 LONGVARBINARY IMAGE (BLOB) |
x |
x |
|||
DATETIME DATETIME4 TIMESTAMP |
x |
x |
|||
BIT |
x |
x |
x |
||
