Exporting to Access – Formats and Data Types - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

SQL Assistant
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Exporting to AccessFormats 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




    BLOB or CLOB

    Text (the LOB file name)

    Other (up to 255 bytes)


    Other (over 255 bytes)


  • 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.