Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Linking to and Querying Access database
 
From:   Dempsey, Mike

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019