Is there any way to parse foreign decimal/double values from a Excel file with OLEDB? However, searches on Google shows this is not a new problem, so put my hope to anyone who maybe have a solution.
MY COMPUTER SETTINGS:
Non english settings on the machine, using the "," instead of "." as decimal separator. I have also tried to change settings on the machine, but no success.
All decimal values from Excel sheet containing a dot, returns a DBNull value. Example 1.5, 0.5 and so on. I want to read column from Excel sheet whatever the decimal format is, "," or "."
And yes I have tested ALL OF THE existing datatypes according to OLEDB. And yes I have done searches on Google.