Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 07 May 2004 @ 17:56:22 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Export from MS Access 2000 to Teradata
From:   Dempsey, Mike

It sounds to me like Access is telling ODBC that the data type of one of the columns is 'type 0' - which is not a valid data type.

I don't know how big this table is but you might be able to do this in 2 steps using SQL Assistant. First connect to Access and Export the data to a file. Then connect to Teradata and Import that file. (You would have to create the table on Teradata before the import if it does not already exist. You would also have to use Notepad, or something, to remove the first line of the Import file [column headers] before importing - something you will be able to avoid using the next release of SQL Assistant.)

This would avoid the problem by exporting/importing all columns in character format. You would however have to select an export delimiter that is not found in your data (or use 'enclose values in quotes') and this will not work if there are any character fields that contain Line Feed characters.

Mike Dempsey
Teradata Client Tools

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019