By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,220 Members | 1,512 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,220 IT Pros & Developers. It's quick & easy.

TransferText truncates Double datatype to 2 decimal places

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
L Mehl wrote:
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


Is you specification correct? :)
--
regards,

Bradley
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.