export a simple text file

  • Thread starter Thread starter G.
  • Start date Start date
G

G.

I'm so frustrated. Why can't I build a macro that can export a text file? I
tried the output to action and got a text file with dashed lines around my
data. I searched this site and found I could use the TransferText action but
this gives me quotes around my data! I've searched the site (and looked at
other resources) but can't find anything that will help me to export just a
simple text file with nothing else but my data - so frustrating. Can anyone
help with what I am doing wrong please? Is it possibly that the data type in
my table is text and not number? When I switch it to number it says that it
is going to delete some of the data in my table. Thank you for helping.
 
G,

Run through the process manually first, via the File=>Export menu. That way
you can control delimiters and text qualifiers. When you get to the final
screen of the export wizard, click 'Advanced' and then save as a
Specfication. Then, in your TransferText macro, enter the name of that
specification.
 
Back
Top