Archives of the TeradataForum
Message Posted: Tue, 27 Jan 2004 @ 11:47:49 GMT
| Subj: || || Re: Access and Decimal(15,5) |
| From: || || Victor Sokovin |
> Teradata V2R5 Demo
> Access: MS Access 2000 SR1
> ODBC: Teradata 3.02.00.02
| ||I receive the decimal values, but without any decimal point: 1234567 instead of 1234.567|| |
| ||So the data is useless...|| |
Decimal point is often the point with ODBC (sorry for the pun). Check the Windows regional settings on your PC and/or Access/MS Office.
In Europe, people often use "comma" as the decimal separator and that confuses some GUI tools.