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

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

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
 
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.
 
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
 
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)
 
Back
Top