Export MS ACCESS 2003 Report Directly to CSV File?

[jpodesta]

I am working on a trade processing project for my company. I would like
to export a report directly to .csv format. I have looked all over in
the groups for a way to do this. Appearently something that would seem
to be fairly simple is not. I had mixed success dropping the report
into excel but upon export is carried over the field headers that I
dont want to appear in the CSV extract.

I really dont want to have to use xls. I want to drop a report cleanly
into CSV. Does anyone know of a way this can be done?

[MGFoster]

jp******@ibtco.com wrote:

I am working on a trade processing project for my company. I would like
to export a report directly to .csv format. I have looked all over in
the groups for a way to do this. Appearently something that would seem
to be fairly simple is not. I had mixed success dropping the report
into excel but upon export is carried over the field headers that I
dont want to appear in the CSV extract.

I really dont want to have to use xls. I want to drop a report cleanly
into CSV. Does anyone know of a way this can be done?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Instead of trying to export a formatted report as a CSV, export the
query that supplies the data for the report. Use the TransferText
method.

If you truly wish to export the report, use the OutputTo method; though,
you'll probably be disappointed with the results.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQnqPuoechKqOuFEgEQIpcQCfV7DkqUsnZOPUbzdgE1W4rk MyLPIAnR9i
unjWcRslDTMGuS8raiXMKX0U
=50i/
-----END PGP SIGNATURE-----

[Chuck Grimsby]

Try Dimitri Furman's TextExport class:
http://www.mvps.org/access/modules/mdl0058.htm or
http://www.users.cloud9.net/~dfurman