There is no direct way of saving a recordset to CSV format or a fixed columns format. You have to loop through rows and columns to do that.
>Is the only way to save retrieved ADO recordset to a fix-width ASCII text file is to output/write each field and record one by one or is there a faster/easier way? I know that ADO has a "Save" method but only two formats (AGTD and XML) are supported.
>
>Also, anyone know a way to easily save a file in XML format to ASCII text? TIA.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com