Exports and decimals

  • Thread starter Thread starter Ben Jammin
  • Start date Start date
B

Ben Jammin

Anyone know how to export a table to a text file and get
more than 2 decimals?
 
Set up an export specification that specifies the decimal format for the
field and then use that export spec in a macro (TransferText) or VBA code
(DoCmd.TransferText).

You set up your spec by starting to do the export manually, and when the
wizard window opens, click on the Advanced button at bottom left -- you then
can set all the export specification parameters and save the spec as
whatever name you want. Then cancel the export and use the spec name in one
of the above methods.
 
Thanks for the help.

I tried what you said but don't see any way to change the
decimals in the Advanced screen.
 
My oversight....that's what I get for doing things from memory!

Replace the field in your query with a calculated field that formats the
output the way you want for decimal points. For example, if I want 4 decimal
places:
OutputField: Format([FieldName], "0.0000")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ACCESS TO EXCEL 1
Exporting not working right 4
export table to excel and maintaining the table number of decimals 8
Exporting Data 2
With export decimals are disappearing 2
How to Export Gmail Emails to PST Format? 4
Rounding difference in Access 2003 text exports 2
Access stripping decimal places in query 1

Back
Top