Exporting to Access – Formats and Data Types
The following applies to exporting data to Access tables:
Teradata Data Type |
Access Data Type |
Byte, SmallInt or Integer |
Integer (maximum 32 bits) |
BigInt, Float, Decimal or Numeric |
Float |
Date |
Date |
BLOB or CLOB |
Text (the LOB file name) |
Other (up to 255 bytes) |
Text |
Other (over 255 bytes) |
Memo |
Note: If the data is being appended, ensure that the table definition matches the data being exported. The data types of the columns should match those of the select statement used in the export, with the optional addition of the AutoNumber column as the first column in the Access table.