How to read a csv file into DataTable

[ad]

I have a .csv file.
How can I read it into DataTable?

 

[Cor Ligthert [MVP]]

Ad,

If you look two messages below you see my answer on that.

Cor

 

[ad]

Thanks,
But I can't find your answer.

Ad,

If you look two messages below you see my answer on that.

Cor

 

[Cor Ligthert [MVP]]

Do you not see a message from Tomb?

Thanks,
But I can't find your answer.

 

[Paul Clement]

¤ I have a .csv file.
¤ How can I read it into DataTable?
¤

Dim TextConnectionString As String
TextConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & "e:\My Documents\TextFiles" & ";" & _
"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, "TestFile")

'...
'...

TextConn.Close()


Paul
~~~~
Microsoft MVP (Visual Basic)