ACC: Exporting to Text file Truncates to Two decimals Places

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q153364

Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

If you have a table that contains a number field with more than 2 decimal places, and you export the table to a text file, the decimal places will be truncated to 2 positions.

Back to the top

To work around this behavior, instead of exporting the table, create a query with the fields that you want to export and use the Format() function to specify the number of decimal places in the number field. For example, if your field has 4 decimal places, the column in the query grid would look as follows:

   Field: Format([fieldname],"##0.0000")

Back to the top

STATUS

This behavior is by design.

Back to the top

MORE INFORMATION

Steps to Reproduce Behavior

Open the sample database Northwind.mdb.
Open the Suppliers table in Design View.

Add a field to the Suppliers table with the following properties:

      Field Name: Cost
      Data Type: Number
      Field Size: Double
      Decimal Places: 4

Close and save the table.
Open the Suppliers table in Datasheet view and scroll right until you see the Cost field. Type data into this field for several records, and make sure the data contains at least 3 decimal places.
Close the table, and on the File menu, click Save As/Export.
In the Save As dialog box, click "To an External File or Database," and then click OK.
In the Save As Type box, click Text Files, and then click Export.
When the Text Export Wizard appears, click Next twice, and then click Finish. When the file has been exported, open the text file. Note that the Cost field is truncated to two decimal places.

Back to the top

REFERENCES

For more information about exporting in Microsoft Access, search for "exporting data," and then "Export data to another database or file format," using the Microsoft Access 97 Help Index.

Back to the top

APPLIES TO

Microsoft Access 95 Standard Edition
Microsoft Access 97 Standard Edition

Back to the top

kb3rdparty kbprb KB153364

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top