I'm importing an excel spreadsheet into an access table and seeing a rounding issue.
The Excel sheet is formatted as a currency and has a value like $ 43.16.
I don't see any additional digits in the cell.
When it imports into the access table field which is a double it comes out as 43.1599.
How can I force the correct amount into the double field?