Windows 7- 64 bit ODBC

[gregmonay]

Hello Code400 Guys,

i just want to ask if anybody here have already encountered this issue.
We bought new PC's with pre-installed win7 64 bit OS. I installed the client access 7 for 64 bit on the PC and everything seems to be ok until I used my excel(2007) extract connecting thru odbc(I added an odbc entry on the 64bit odbc driver). The extracted numeric values in excel are all rounded off with decimal point. (example 3.85 is shown 4.00). This same excel extract is working fine when used in winxp 32 bit.

Thanks,
Greg

[tomholden]

Re: Windows 7- 64 bit ODBC

on your ODBC settings for the DSN check the data types tab for the rounding settings...

[gregmonay]

Re: Windows 7- 64 bit ODBC

Thanks Tom but I tried each rounding settings already but it still gives me the rounded off numbers in my excel.
What should be the settings on rounding off to not round off? Is there any settings that I need to set?

Thanks,
Greg