Archives of the TeradataForum

Message Posted: Thu, 18 Feb 2010 @ 14:15:14 GMT

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

If you plan to move the Teradata data to Access you might want to use SQL Assistant. Switch on Export and execute the query that extracts the data rows you need.

When prompted for the export file name select a type of Microsoft Access and point it to the Access database that contains the other table. (It will ask you for a table name to use for this extract.)

Note that some data types will be stored as VARCHAR since they have no equivalent in Access.

Mike Dempsey
Teradata Client Tools

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