>>>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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.