Forum Discussion
Reading a non-rounded value from Excel cells using OPENDATASOURCE
Reading a non-rounded value from Excel cells using OPENDATASOURCE I have the following situation: I have an Excel document that contains in a cell a value 10,45. Format of the cell is “# ##0,0;-# #...
Format of the cell is “# ##0,0;-# ##0,0”. Therefore, the value 10,45 is displayed in Excel as rounded value “10,5”
The data provider ACE don't care about any Excel format information, it picks the value as it is. You have to round the value on your own, see
Thank you for the answer.
“The data provider ACE don't care about any Excel format information” – I see. Don’t you know – is there any other data provider that could solve this my problem?
“You have to round the value on your own, see”- sorry, not sure how this approach could help me. Look: in the above example my T-SQL code receives (from the ACE provider) value “10,5”, not “10,45”. How in this situation could the ROUND help me? Or I misunderstood something?
Thanks in advance
