TransferText truncates Double datatype to 2 decimal places

L

L Mehl

Hello --

Goal is to export data from tblData having this structure:
dateRecord Date/Time
textFrom Text 4
textTo Text 4
valueRecord Number Double (format = Standard, Dec Pl = 12)

Using the following code

DoCmd.TransferText acExportDelim, strSpecName, _
"tblData", strFilename & ".txt", True

truncates valueRecord to 2 decimal places; some values in the table have
many more digits after the decimal point.

Is there code I should add, or changes necessary to the spec in order to
export valueRecord values accurately?

Thanks for any help.

Larry Mehl
 

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

Top