Export from Access to Text file: Specified number of decimal place

H

HelloKitty

Hi,

How could it be set up to export from Access to Text file with desired
number of decimal places, say 6 decimals? Can Access 2000 do this?

It seems Access usually retains 2 decimals in exporting to text files.

Thanks a lot for your help in advance!

Sincerely,
 
V

Van T. Dinh

You can create a Calculated Field in a Query like:

MyFormattedNumber: Format([NumberField], "0.000000")

+ other Fields as required and then use the Query as the DataSource for your
export.
 

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

export teble to text keeping number format 2
Export decimals to txt 4
Decimal Truncation Issue upon Import - Access 2007 1
Error exporting decimal values in csv file 0
Export Data from Access to Excel 0
Exporting Number with Decimals to Text Rounds to 1 decimal place 1
file type export problem 5
How do I keep leading zeros and remove the decimal point when expo 2

Top