Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 384
  • Last Modified:

Access Import Rounding Issue

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?
0
stopher2475
Asked:
stopher2475
  • 3
  • 2
3 Solutions
 
jerryb30Commented:
if you format it as a number in excel, what does it look like?
0
 
peter57rCommented:
Try changing the format in Excel to increase the number of visible decimal places.  I suspect you will see the same as you see in Access.
0
 
stopher2475Author Commented:
I did try that. It will look like  43.16.
Maybe I should try formatting the column as a number anyway before importing?
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
stopher2475Author Commented:
So I tried formatting to "General" before importing and that seems to have fixed the issue.
Weird that Access will import them differently. There are no extra digits in the Excel file.
0
 
jerryb30Commented:
It is weird, but binary fractions can be problematic. I am not sure that Access and Excel do things exactly the same way.  Going from a (presumed) currency data type to a double might have caused the issue.
0
 
stopher2475Author Commented:
Selected my comment because it contains the method to solve the problem.
Experts were on the right track. Splitting points between the most relevant.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now