Need help to create table through ms access 2007

UDA

Need help to create table through ms access 2007

Hi, I would like to use MS access 2007 through ODBC Teradata 3.05.
I'm having a problem to insert date format:
It gives me ODBC call failed
NCR ODBC Teradata Driver Teradata Database Number of fractional digits out of range #-5401.
My date column is named HireDate and the data is on excel.
I've linked the xls file as a linked table to access.
The Data Type is Date/Time and format id DD/MM/YY.

I reformatted it to YY/MM/DD and same error.

Any suggestion/help would be appreciated.

Thank you
1 REPLY
Teradata Employee

Re: Need help to create table through ms access 2007

Check the help file regarding the "Custom Options" for MS Access compatibility at the bottom of the ODBC Configuration / Options / Advanced dialog.