>>>>>When working with the OLEDB driver via NET, is it possible to SELECT into a CSV or other text file format? Seems like it only supports DBF.
>>>>
>>>>No (AFAIK) but you could use Stored procedure to do it.
>>>
>>>Great idea. Can you tell me how to execute a stored procedure in NET? I have

>>>		Dim oConnVFP As New Data.OleDb.OleDbConnection(ConfigurationManager.ConnectionStrings("VFPLibrary").ConnectionString)
>>>		Dim strCSV As String = "do createcsv"
>>>		Dim objCommandCSV As New System.Data.OleDb.OleDbCommand(strCSV, oConnVFP)
>>>
>>>		oConnVFP.Open()
>>>		objCommandCSV.ExecuteNonQuery()
>>>		oConnVFP.Close()

>>>but its not quite right.
>>
>>Have no idea :-)
>>Maybe
>>
>>Dim strCSV As String = "createcsv()"
>>should work.
>>BTW are you use VFP Database or free tables?
>
>Dim strCSV As String = "createcsv()" && doesn't work either. I'm using a DBC.

You have to set OleDbCommandType to be StoredProcedure. And then I think you just need to give a name of your sp and also set parameters separately if the SP has parameters.

However, I only used it for SQL Server, but I believe it's very similar for VFP too.