By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,709 Members | 2,157 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,709 IT Pros & Developers. It's quick & easy.

Export MS ACCESS 2003 Report Directly to CSV File?

P: n/a
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?

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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-----
Nov 13 '05 #2

P: n/a

This discussion thread is closed

Replies have been disabled for this discussion.