Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 30 Sep 2002 @ 21:56:10 GMT


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


Subj:   Re: MsAccess Updating Teradata Table
 
From:   Marc Le Gall

Hello John,

Well in my case, I do have a Date column and a Time column. (some other tables have date/time column but they are not my problem right now)

Still, it is the same phenomenum, Add is okay, Browse is okay but not the update. Also I found that my time column is defined as Text in Access. I do not have control on that part.

Meanwhile, with the Help of a collegue, the best trick found is to create the table in access which is the copy of the Teradata table. Then do All the modification inside this table. And then upload the data into the Teradata table.

This has two good points for me. I do have a backup of my test cases and I can do all the modifications needed.

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: 15 Jun 2023