Is there anyway to export a report file to CSV file format instead of Excel file format? THANKS!!! <

  • Thread starter Thread starter Sean
  • Start date Start date
Your reply is fast!

More Detailed Scenario:
I preview a report. I am able to export the report to Excel document using
Docmd.OutputTo method.
How can I use TransferText to export the contain from the report to CSV file
format?

Thanks.
 
TransferText requires that the data be in a table or query. What is the
RecordSource for your report? Is it an unfiltered query or table? or is it a
filtered subset of a table or query?
 
It is an unfiltered query.
I think TransferText is not able to extract the data out from the report.

Thanks.
 
No, TransferText can't edtract data from a report, but it can export the
same query that the report is using.
 
Hi Ken,

Really appreciate all your replys!

Have a nice day!


Regards,
Sean
 
You must log in or register to reply here.

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

Similar Threads

How to Export Gmail Emails to PST Format? 4
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Which is the best MBOX Converter Tool different formats conversion? 4
Export to csv 6
Best Gmail Backup Tool to use in 2025? 3
File Export to CSV 1
Exporting Report to CSV Format 5
CSV file losing "#" in column headers 1

Back
Top