TransferText format error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

reiko said:
I've used the following code in VBA for years, now it export the data in
Click to expand...
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",
Click to expand...
"\\tornado\diatom\peru\data\T0s5.txt"
 
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)




reiko said:
I've used the following code in VBA for years, now it export the data in
Click to expand...
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",
Click to expand...
"\\tornado\diatom\peru\data\T0s5.txt"
 
Hello, Yes, I've checked the output specification and I've even tried to generate a new specification but the results are the same. I think it must be a higher level problem. Thank You for any help you can offer. -

----- Ken Snell wrote: ----

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


--
Ken Snel
<MS ACCESS MVP

reiko said:
I've used the following code in VBA for years, now it export the data i
Click to expand...
the incorrect format, '17.' instead of '17.25'. I'm losing the precision o
all the data. Also integers are being exported as '482.' The only thin
that has changed is that I've run the 'recommended' Office updates. Pleas
help"\\tornado\diatom\peru\data\T0s5.txt
 
I suppose it's possible that the file that contains this code has become
corrupted. Try deleting the code, compact/repair the database, then put the
code back in.

If not, import all the objects into a new database and see if all works ok.

--
Ken Snell
<MS ACCESS MVP>

Reiko said:
Hello, Yes, I've checked the output specification and I've even tried to
Click to expand...
generate a new specification but the results are the same. I think it must
be a higher level problem. Thank You for any help you can offer. -R
 
Back
Top