Export as txt truncates after office updates

S

suek

The following line worked fine for a year (when exporting
from access) until Office2002 updates were installed this
week.
DoCmd.OutputTo acOutputReport, stDocName,
acFormatTXT, "C:\myfile.s01"
After updates the output record stops around cc168-178
instead of the correct end of 253. Our work around is
changing the output format from "acFormatTXT"
to "acFormatRTF" and then using Wordpad to 'Save As' a txt
file (ugh!). Are there any patches for this out there?
thx, sue
 

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

Similar Threads

VBA export snafu after office updates 1
memo fields output to text file 1
Removing quotes from a csv file after DoCmd.TransferText 7
subreport lines truncate on export to rtf or txt format 0
Microsoft Office 2007 Manual Uninstall Help 3
Office Update Scan won't work - Office XP Professional 2002 9
Office 2003 Update to SP1 after install of XP SP2 4
MBSA, Office Update, Versions, Failures 20

Top