export a simple text file

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.
 
S

Steve Schapel

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.
 

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

Top