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

S

Sean

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.
 
K

Ken Snell [MVP]

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?
 
S

Sean

It is an unfiltered query.
I think TransferText is not able to extract the data out from the report.

Thanks.
 
K

Ken Snell [MVP]

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