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
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