ODBC - decimal symbol

Not applicable

ODBC - decimal symbol

Hi all,

I'm importing data from Teradata database into MS Access database (Windows 7) using an ODBC driver. The decimal symbol is set to '.' (because the 'Use Regional Settings for Decimal Symbol' is unchecked in the ODBC driver options). The decimal symbol is different in OS (',') thus the import of decimal values is not correct.

I'm not allowed to change the ODBC settings. I can't change the decimal symbol setting in OS because of some other software.

Is it possible to override the ODBC driver setting - for example in the ODBC connection string?

Thank you for your help........