A
ad
I have a .csv file.
How can I read it into DataTable?
How can I read it into DataTable?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Cor Ligthert [MVP]
Ad,
If you look two messages below you see my answer on that.
Cor
If you look two messages below you see my answer on that.
Cor
A
ad
Thanks,
But I can't find your answer.
But I can't find your answer.
Cor Ligthert said:Ad,
If you look two messages below you see my answer on that.
Cor
C
Cor Ligthert [MVP]
Do you not see a message from Tomb?
ad said:Thanks,
But I can't find your answer.
P
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)
¤ 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)