I am writing an application in VB6 that sits on top of Access 97.  I have a recordset that I would like to export to a .txt or .csv file at the push of a button on a VB6 form.  Easy to do in Access but how do you do it in VB?

Hi,
Recordset.Save will save to a ADO.Stream object, or Recordset.GetRows or Recordset.GetString (ADO2.6) will help.
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

Thanks for this but i cannot fulfill my objective.  I have used the recordset.save method but I want tio use this fil for importing to another application.  The csv file created is not formatted in any way.  Do i have to format it in VB (i.e. split all the fileds with commas etc) or is there a simpler way?