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

[MadHungarian]

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.

 

[Nikos Yannacopoulos]

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

 

[MadHungarian]

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

 

[Nikos Yannacopoulos]

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

 

[MadHungarian]

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.

 

[Nikos Yannacopoulos]

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.

: