Jay:
One alternative is to use the TransferText method on the underlying table or
query behind the report. For example:
DoCmd.TransferText acExportDelim, "MySpecificationName",
"MyTableOrQueryName", "H:\MyExportFileName.csv", True
You can create an export specification by choosing Export from the File menu
and then choosing "Text File" in the Save As Type combo box. This will
start the export wizard, and you can choose your delimiter (comma in this
case) and other parameters of the export. You can save the export
specification using the Save As option.
The fourth parameter of the TransferText method specifies whether or not to
include the field names in the file (True in my example).
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or warranties.
I have a report of customer summary: Name, ID, and Reason, Time, and Commnet
fields. I want to achive these data in comma separated archived file. How
can
I do that?
Thank you.
