converting to csv (1 Viewer)

[dgoulston]

how do i convert my report to csv format? is there an easy way??? if it needs to be done usin the VB coding, has anyone got any sasmple vb code for doin this?

please help asap//

thankyou in advance
darren goulston

 

[Pat Hartman]

The implication of .csv format is that all the records will be identically formatted. Typically, reports contain lines of many different formats. Therefore, it doesn't make sense to export a report in that format. If all you want to export are the lines of the detail section, you should be able to simply export the query that the report is based on.

 

[dgoulston]

thanx

yep ur tottaly right, after posting that post i realised that, and then figured out how to do it... so its fine, thanx for ur attention anyways.

 

[BLeslie88]

Well here is VBA code to do so...
DoCmd.OutputTo acOutputReport, "rptAllDiv2", acFormatTXT, "D:\Temp\rAllDiv2.CSV", False

I personnally prefer exporting to 'acFormatSNP', 'rAllDiv2.SNP' files so that the report looks exactly like it does in Access. Otherwise why not excel output, unless this is meant for a upload to another system...?

Good luck hope this helps...

Bri