CSV query syntax for MS ODBC Text Driver?

  • Thread starter Thread starter Chris Sells [MSFT]
  • Start date Start date
C

Chris Sells [MSFT]

[1] defines the syntax to create a connect to a text file. Does anyone know
where to find the description of the syntax this driver supports? Thanks.

Chris Sells

[1]
ms-help://MS.VSCC.2003/MS.MSDNQTR.2003APR.1033/enu_kbvbwin/vbwin/187670.htm
 
¤ [1] defines the syntax to create a connect to a text file. Does anyone know
¤ where to find the description of the syntax this driver supports? Thanks.
¤
¤ Chris Sells
¤
¤ [1]
¤ ms-help://MS.VSCC.2003/MS.MSDNQTR.2003APR.1033/enu_kbvbwin/vbwin/187670.htm
¤

Use the Jet OLEDB driver with the Text ISAM instead:

Dim TextConnectionString As String
TextConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & "c:\TestData" & ";" & _
"Extended Properties=""Text;HDR=NO;"""
Dim TextConn As New System.Data.OleDb.OleDbConnection(TextConnectionString)
TextConn.Open()

Dim da As New System.Data.OleDb.OleDbDataAdapter("Select * from test.csv", TextConn)

Dim ds As DataSet = New DataSet("CSVFiles")
da.Fill(ds, "test.csv")


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top