Archives of the TeradataForum
Message Posted: Thu, 18 Feb 2010 @ 14:15:14 GMT
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.
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023