Hello ,

This is incredible.
We've got a process that read Excel file using a SQL query on Microsoft.ACE.OLEDB.12.0.

In the Excel file, the cell's value = 0,5
In the SQL query, the value = 1

I have tried to save the Excel file as a CSV, and I can see the "0,5".

We don't understand, we have no clue !!!

Here is the query :
SELECT activite.F9
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;HDR=YES;IMEX=1;Database=C:\GammaWeb_TMD\Imports\RMA\Arch\RMA201011_Test.xls',
'SELECT F1,F9 FROM [Activité mensuelle$B20:AJ23]') as activite
where F1 like 'F%'


Do you have any advice,
Thanks in advance,
Olivier