Archives of the TeradataForum

Message Posted: Tue, 27 Jun 2006 @ 17:15:04 GMT

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

I am not exactly sure what you are trying to do here.

If you try to use Access to directly export the table to Teradata (using the ODBC Datasource option) you will probably get the 'unknown infotype 0' error that was reported recently on this group. (It appears to be a bug in MS Access)

If you export to a text file (use the advanced options to specify a tab delimiter, 'no quotes' around strings, and a date format of yyyy-mm-dd with zero padding) the exported text file looks fine ... except that the dates also have a 'time' component, which later causes it to fail the conversion to date data type.

You can however insert these dates into a CHAR(19) column then use insert/select to copy to a table in which they are defined as 'Date'. Use substr(datefld,1,10) when selecting the date fields for this insert.

As an alternative to using Access Export, and having to set the advanced options, you could just use Queryman to Export the data from your Access table.

However you will still have the problem of the 'time' component on the date fields so it doesnt buy you much.

I'm not aware of any Access function that allows you to extract the date portion of a Date/Time column, or to request the Left 10 characters etc. If there is such a function then you could perform your export in Queryman using that function and it would create a file that could then be imported with no trouble.

BTW - Queryman 6.0 is about 5 years (and 4 versions) old now.

Mike Dempsey
Teradata Client Tools

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