MISSING ZERO IN IMPORTED EXCEL DATA 104.10 = 104.1 ????HOW CAN I .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I import numeric data from excel spreadsheet formatted as numeric with 2
decimal places, any data where the decimal ends in 0 is missing,,,ie 104.10
in excel shows up as 104.1 in access. I need the data to be in complete
terms for an external program to use the data.
 
When importing from Excel (or any other external file format, for that
matter), Access imports values, not formats. In reality it does not lose
any real information, since 104.10 = 104.1, right? Now, how you show
data in Access, is a different subject, and that's what you are talking
about: formatting. Wherever you want to show the two decimals (or
whatever), just apply the format that you want, be it on a form or
report control, or even a table field (though tables are not meant for
displaying, entering or editing data).

Need any more specific help?

Nikos
 
Even when I set the Access field to 2 decimal places, it still shows only
one. I'm using that field in a visual basic data form and it does not
recognize a .1 to mean .10 . I worked around the problem, but still would
like to know how to get Access to display the full decimal place.

Thanks
 
Displaying and storing are two different things! You can impose a
certain format so you display X decimals. but that doesn't change the
way the value is stored (unless of course you store as text, which is
not a good idea for numerical values). Now, if your VB front end says
0.1 <> 0.10 then most likely it is treating the values as text rather
than numbers. In a nutshell, Access is doing the right thing in the
storing, the problem is somewhere in your VB app.

Nikos
 
You're right, My VB App converts the numeric data into text because I need to
use the numeric data to locate a specific file, so the file handler requires
"text" data. So I wrote a patch in that app that gets me around that
problem.

Thanks for your help and input.
 
Welcome! Glad it worked.

Nikos
You're right, My VB App converts the numeric data into text because I need to
use the numeric data to locate a specific file, so the file handler requires
"text" data. So I wrote a patch in that app that gets me around that
problem.

Thanks for your help and input.

:
Click to expand...
 
Back
Top