Export recordset to ASCII file

[VLT]

Hi there,
How can I export recordset data to ASCII file using VB code? I'm looking for the same effect as "DoCmd.TransferText acExportDelim......" has in Access?
Thanks

[Andrew R.]

You can do it manually: in a loop read all values of your recordset and write those into the text file.

[Iouri]

1.Create a recordset
2.Write records to the text file


Open "c:\temp\temp.txt" For Output As #1 'to write to

rs.movefirst
do while not rs.eof
Print #1, rs!Field1 & vbTab & rs!Field2 & etc...
rs.movenext
loop
Close #1


Iouri Boutchkine
iouri@hotsheet.com