Exporting Number with Decimals to Text Rounds to 1 decimal place

G

Guest

I have data in Access that I need to export to a text file. This data has 4
or more decimal places and when I export the data the text file ends up with
rounded data to the first decimal place. Please help:)

Thanks,
Craig
 
K

Ken Snell \(MVP\)

Use a query as the source of the data to be exported. In the query, replace
the field in question with a calculated field that uses the Format function
to give you the desired number of decimal places (in this example, 7
places):

Format([FieldName], "0.0000000")
 

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

exporting as text cutting off significant digits 2
exporting to text need decimals 1
Export from Access to Text file: Specified number of decimal place 1
export teble to text keeping number format 2
Access stripping decimal places in query 1
Exporting to text file 1
Exporting Double without Decimals 3
Decimal Places when exporting to txt 3

Top