Exporting to Access – Formats and Data Types - SQL Assistant

Exporting to Access – Formats and Data Types

The following applies to exporting data to Access tables:

If the Access database does not exist it is automatically created in Access 2003 format.

SQL Assistant can add an AutoNumber column (row number for the result set) as the first column in the export table. Specify whether this column is required using the Export  tab of Options.

When the Access Table is created, SQL Assistant maps Teradata data types to Access data types as follows:

Table 24: How SQL Assistant Maps Teradata Data Types to Access Data Types 

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

If the Access table already exists, the exported data either replaces or appends to it depending on whether or not you selected the Replace Table check box when specifying the table name.

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.