Hi, does anyone know how to direct the results of a query to a standard
ASCII text file?  thanks

 You could For/Next thru the recordset and write each record to a file...or
the clipboard...etc

John

Jan;
Search the On-line books for list and you will see an example for Unbound
list box.  It shows how to loop through a recordset additem to a list box.
You can use it as an example to loop and send to a file.

        sCatDatabase = App.Path & "\macro32.mdb"
        datCategory.DatabaseName = sCatDatabase
        Dim Rs As Recordset
        datCategory.RecordsetType = 1         ' Dynaset-type Recordset.
        datCategory.RecordSource = "SELECT Name FROM qryCategory"
        datCategory.Refresh                       ' Open the database.
        cmbSearchID.Clear                      ' Clear out the list box.
        Set Rs = datCategory.Recordset

        Do While Rs.EOF = False
            cmbSearchID.AddItem Rs(0)      ' Add the field.
            Rs.MoveNext                     ' Move to the next field.
        Loop