We use OpenRowSet() to import Excel data. We discovered that if a field in Excel is formatted as currency that the import is maxed out at 4 decimals. We have values such as 0.13777. They are shown in Excel as 0.13$. They are imported at 0.1308. This creates an offset of 0.01$ in our total when we multiply that with a quantity as it is actually not the same value we have in our database. As anyone found a way to have the import respect the number of decimals in Excel or to simply import the real value when the field is formatted as currency?