Bug? Export to text file drops numeric data right of the decimal

[Guest]

Hi all,
I am trying to do a simple table export to a text file in Access 2003. The
data has numeric values with multiple digits to the right of the decimal
point (ex: 25.2687). The data is stored as a number / double. When I do the
export to a comma demitted file the digits after the hundredths place gets
dropped (ex: 25.2687 becomes 25.26). The wizard shows the data correctly in
the viewer. The data appears correctly in the data view and queries. But
when I view the generated text file the data is missing.

Am I missing something here? Is this a bug? If so isn’t the ability to
import and export data between Access and some other enterprise database part
of the core uses of Access? I know one workaround is to change the numeric
field to text and then export. But I really want a fix or and explanation
that this is user error. Ideas/Help?

Thanks in advance,

Andy

PS: I read the following on the Help and Support page but it’s not exactly
the same thing. Plus it gives a similar workaround but no mention of solving
the problem.
http://support.microsoft.com/?scid=kb;en-us;301915&spid=2509&sid=50

 

[Ken Snell \(MVP\)]

The behavior that you see is by design.... that is how the ACCESS text file
export feature works for numbers.

To get all the decimal places, you must use a Format function in a
calculated field in a query in order to fix the number of decimal places you
want, and then to export the query.

 

[Guest]

Ken,

Thank you very much for your reply. My personal opinion is this seems like
poor design. I certainly hope the MS Access Development Team doesn’t design
any fighter jet cockpits - with their philosophy they will be putting the
ejection seat controls next to the fire missiles button - it's an accident
waiting to happen.

Thanks again for answering my thread,

Andy

 

[Guest]

I think this uses your system settings for numbers.

I'm comfortable with that: inexperienced users get their
numbers in the default format, power users can learn
(perhaps from somewhere like here), to format their
numbers as required.

(david)