Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 07 May 2004 @ 18:24:17 GMT


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


Subj:   Re: Export from MS Access 2000 to Teradata
 
From:   Slook, Ed

Gordon,

In order to work out the MS Access date problem, NCR has come up with a patch for MS Access. It has some different property settings that allow the DATE() function to work w/ Teradata. If you recall, any driver after 2.06 had a date/timestamp conflict w/ MS Access. The 3.03.00.02 patch resolves this, but we have to use a separate DSN to take advantage of it. Any MS Access databases you have should be re-linked to this new ODBC.

All things being the same except for the driver options:

Driver Options:

Check "Use X Views" here. Then hit the advanced button.

Advanced Driver Options:

Check "Enable MS-Access Timestamp Interoperability Mode


--Ed



     
  <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