Exporting Report to .txt file

I

Ian Roger

Can anyone help me to export an access report to a new text file with a macro?
Thank you.
 
S

Steve Schapel

Ian,

Probably it is best not to use a report for this. If it's going to a
text file, then it is almost certainly going to be better to base your
export on the query that the report is based on. If I am worng about
this, please post back with more information about what you are trying
to achieve.

The macro action to use is the TransferText action. By default, this
will export to a comma delimited text file with ""s around the text
format data. If you want something other than the default output, you
can control it by running through the process manually via the
File|Export menu, and at the final screen of the export wizard, click
the Advanced button, and save your definition as a Specification, which
can then be entered into the SpecificationName argument of the
TransferText macro.
 
I

Ian Roger

Thanks Steve,
I am using access reports to create text files containing html tags so that
I can regularly update a webcatalogue. These I export to .htm files and post
to website. I can't achieve this direct from the query I don't think?

Ian
 

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