converting to csv

[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

 

[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