Hello,

I need to dump a recordset into a tab delimited text file
Does anyone know a quick way to do this.

I know how to do it field by field, but I want to dump multiple tables into multiple text files quickly.

Thanks in advance for any help/suggestions

You can Persist the ADO recordset to a text file in XML format using the built-in MS_Persistence provider, you will the have the table structure as well as the data. i.e.

rs.Save ""c:\testfile.txt", adPersistXML

Or reference the Microsoft Scripting Object and do it manually. Here is some sample code:

Dim fso As Scripting.FileSystemObject
Dim MyFile

Set fso = new Scripting.FileSystemObject
Set MyFile = fso.CreateTextFile("c:\testfile.txt", True)
MyFile.WriteLine(rs.Fields("Field1") & rs/Fields("Fields2"))
MyFile.Close

Sorry for not specifing, will this work in VB

Thanks

Yes the code is VB code.

Ok thank you the first option "rs.Save ""c:\testfile.txt", adPersistXML"

Did not accomplish what I was trying to do.

Thanks