TransferText format error

[reiko]

I've used the following code in VBA for years, now it export the data in the incorrect format, '17.' instead of '17.25'. I'm losing the precision on all the data. Also integers are being exported as '482.' The only thing that has changed is that I've run the 'recommended' Office updates. Please help

DoCmd.TransferText acExportDelim, "MAExport Specification", "MAExport", "\\tornado\diatom\peru\data\T0s5.txt"

 

[Ken Snell]

Just a guess, but perhaps the specification "MAExportSpecification" no
longer contains the correct settings. Have you checked it to be sure it's
still correct?


--
Ken Snell
<MS ACCESS MVP>

I've used the following code in VBA for years, now it export the data in

the incorrect format, '17.' instead of '17.25'. I'm losing the precision on
all the data. Also integers are being exported as '482.' The only thing
that has changed is that I've run the 'recommended' Office updates. Please
help.

DoCmd.TransferText acExportDelim, "MAExport Specification", "MAExport",

"\\tornado\diatom\peru\data\T0s5.txt"

 

[Van T. Dinh]

Have you checked the text file to make sure that it has the same format with
an old text file that worked?

If it has a different format, you may need to modify the Import Spec to
accomodate the new format.

HTH
Van T. Dinh
MVP (Access)

I've used the following code in VBA for years, now it export the data in

the incorrect format, '17.' instead of '17.25'. I'm losing the precision on
all the data. Also integers are being exported as '482.' The only thing
that has changed is that I've run the 'recommended' Office updates. Please
help.

DoCmd.TransferText acExportDelim, "MAExport Specification", "MAExport",

"\\tornado\diatom\peru\data\T0s5.txt"