Export data macro

G

Guest

I created a macro that is supposed to take data from a table and make a text
file with it.

When I try to run the macro, it says "Cannot update. Database or file is
read-only". For the macro action, I selected "Transfer Text". For the details
at the bottom I selected the following: Transfer Type is Export Fixed Width
(because that's how I wanted my data, which is specified in the Specs
section), Specific Name is the Spec I saved when I did the export wizard,
then I named the table and file name, all of which appears to be correct.

2 questions: what am I doing wrong, and how do I specify where the text file
will appear when it is created?
 
G

Guest

Have you tried Macro Action "RunCommand" and for the box at the bottom output
to TXT or Output to RTF, this throws up Word with the output table which you
can then save.

HTH Mike B

--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all,
you have shouted at and blamed the innocent,
and asked everyone you know,

READ THE INSTRUCTION MANUAL.
 

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