Exporting to Access – Formats and Data Types - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2430
Product Category
Teradata Tools and Utilities
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 the Options dialog.
  • When the Access Table is created, SQL Assistant maps Teradata data types to Access data types as follows:
    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.
    If the data is being appended, make sure 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.