Recordset

Ok, this is really simple, and probably already been explained before, but I have a Recordset that I need to export into an Excel file.
Do I have to use a Do While !rs.eof loop to export the entire record set and loop through the recordset one record and column at a time, or is there an easier way to do this? If I do have to loop through, what exactly are the functions for doing this? I would imagine I need rs.MoveFirst before the loop is started but how do you move from record to record?

Thanks

if you are doing this in Access, here is a simple way of doing it:


'you can also use acSpreadsheetTypeExcel8, acSpreadsheetTypeExcel7 etc.
'setting the last parameter to True includes the Field names in the Excel file
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "MyTable", "MyTable.xls", True

You can also use an SQL statement and export this directly into Excel.