Write recordset to file

[MDA]

Hi all,

Could someone help me with an example of writing a recordset to a text file. I would like to use ADO that will connect to SQL Server. I have about 10 columns of data and have to make sure there are no quotation marks.

I actually need the file in CSV format if any hints on that as well. Any examples or ideas are greatly appreciated.

Many thanks in advance..

Best regards,

Mike

 

[IonelBurtan]

ADODB versions higher than 2.6 provide a method called Sve for the ADODB.Recordsets, it can save your Recordset in XML format.

Hope this helps, s-)

Blessed is he who in the name of justice and good will, shepards the week through the valley of darknees...

http://www20.brinkster.com/ionelb

 

[RobS23]

Check out the FileSytemObject's TextStream. Very easy to use! you'll final output code will be based on a recordset something like


With TStream


.Write RSt(0) & "," & rst(1) & "," & Rst(2)...and so on for each column of data

rst.movenext ....for each row


end with

 

[IonelBurtan]

sorry, bad typing. the method name is Save.

To read the files created with save you use the classic Open method. s-)

Blessed is he who in the name of justice and good will, shepards the week through the valley of darknees...

http://www20.brinkster.com/ionelb