Skip to Content
0
Former Member
Oct 31, 2012 at 12:05 PM

Problem while saving recordset result to csv file using "SaveToFile" option

117 Views

Hello All,

I am trying to save my recorset result to a csv file but while doing that system is generating a csv file with xml data.

Code :-

oRecSet.DoQuery("Select U_ItemCode,U_ItemName,U_Qty,U_Price From [@TEST] "

)

oRecset.SaveToFile("C:\Test.csv")

While executing it system is showing xml type data in csv format.

How to save the resultset as csv file .

Regards,

Amit