I'm creating a VB6 application that needs to export data to different formats that the end user will define.
The data is comming from an ADO recordset and needs to be exported to any of these formats:
.csv, .txt, .xls
What approach should I use to do these exports? I've played around using the Write statement, but i have to loop through every record and every field, which gets tedious and slow, and doesn't work for the xls :p