The following table shows the acceptable source datatypes that the access service can convert into corresponding target destination datatypes.
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 |
Datatypes resulting from this conversion are converted into actual datatypes in the target column, as shown in Table 9-2. 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-1 may not be available
for express transfer. It varies and depends on the ODBC driver that
is used.
