Export data macro

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top