stripping out extraneous data from a text file download

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I have a macro which downloads data into a text file
which contains e-mail addresses from a query. The
problem is that when I go to import this into another
program there is a bunch of extraneous characters in the
text file that Access adds for some reason. Between each
line of e-mails is a line of dashes ------------------.
Also, before and after all e-mails is a | mark. Is there
a way to have this stripped out before downloading this
file? I only want my data which would be the e-mails and
not all of the extra stuff.

Thanks,

Chuck
 
Hi Chuck

It sounds as if you're using the OutputTo macro action. Use TransferText
instead.
 
Back
Top