Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 20 Sep 2002 @ 22:32:06 GMT


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


Subj:   MsAccess Updating Teradata Table
 
From:   Marc Le Gall

I try to create and update data for teradata tables. Since it is test cases the volume is not a concern. I want to do that via an online method. No FastExport, MLOAD, BTEQ, etc.

Also Queryman does not allows direct update.

With SAS, I succeed to directly browse the data but I did not find a way to update them. (SAS 6.09)

The best solution up to now is to connect via ODBC MS ACCESS to TERADATA. It works well to browse and add new rows. However, the update does not work as soon as one of the columns carries Time information or Date/Time stamps.

Does anyone found a solution to this update problem.


Thanks,

Marc.



     
  <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: 27 Dec 2016