G
Guest
Can anyone help me to export an access report to a new text file with a macro?
Thank you.
Thank you.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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.
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.
G
Guest
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
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
S
Steve Schapel
Sorry, Ian, you've lost me completely here. Maybe an example would help?