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


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 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


  <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