Export as .csv via vba

[GrantyJPS]

Hi all,

in my current project, I need to manipulate a business objects report from an Access database, then export the resulting data as a .csv file so I can use the data later on.

The manipulation part is all done and fine, but I can't seem to be able to export as a .csv file programmatically (Although I can via the GUI Data-->Data Manager-->Export etc). ExportasText/Html/RTF/PDF arent doing the job as they all contain lots of formatting characters/headers or the data is space-delimited.

Does anyone know how to export just the result set as a non-formatted .csv file?

Thanks in advance
J.

 

[blom0344]

This may be a first step:

http://www.islink.com/isi_library_downloads_BO_vba.htm

T. Blom
Information analyst
tbl@shimano-eu.com

 

[GrantyJPS]

No dice there, it only shows how to export in the formatted file types

Thanks for replying tho.