Keep decimal places when exporting to text files from Access

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

Guest

Digits to the right of the decimal are lost when creating an Export file.
Should be able to automatically fill the number of specified digits with
zeroes if there is not data in the resulting export file. Thus a field
displaying as 1.0000 in the Access database should look like that in the
resulting export file.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...02688&dg=microsoft.public.access.externaldata
 
Create a query that has a calculated field to format the number the way you
want it to be (using Format function), then export the query.
 
Back
Top