G
Guest
Hi
How do I pharse a CSV file and send the data to a database. This file is hugh
Thanks
How do I pharse a CSV file and send the data to a database. This file is hugh
Thanks
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.
G
Guest
Use the OleDb provider to read the csv file just like you would for a database
Tu-Thac
www.ongtech.co
----- Saif Khan wrote: ----
Hi
How do I pharse a CSV file and send the data to a database. This file is hugh
Thanks
Tu-Thac
www.ongtech.co
----- Saif Khan wrote: ----
Hi
How do I pharse a CSV file and send the data to a database. This file is hugh
Thanks
W
William Ryan eMVP
you can use the ODBC Connection to do it..check out the Text section on
http://www.connectionstrings.com/
Or you can use a Regex.Split for instance but the former approach would be
much faster in all likelihood
http://www.connectionstrings.com/
Or you can use a Regex.Split for instance but the former approach would be
much faster in all likelihood
C
Cor
Hi Saif,
You can make a dataset, but with that you do not have it in your database.
(The delimiter has to be in your culture setting)
But it is a start. Here how to do it.
I hope this helps?
Cor
\\\
Private Sub Form1_Load(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
Dim file As String = "Test2.txt"
Dim path As String = "C:\"
Dim ds As New DataSet
Try
Dim f As System.IO.File
If f.Exists(path & file) Then
Dim ConStr As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
path & ";Extended Properties=""Text;HDR=No;FMT=Delimited\"""
Dim conn As New OleDb.OleDbConnection(ConStr)
Dim da As New OleDb.OleDbDataAdapter("Select * from " & _
file, conn)
da.Fill(ds, "TextFile")
End If
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try
End Sub
///
You can make a dataset, but with that you do not have it in your database.
(The delimiter has to be in your culture setting)
But it is a start. Here how to do it.
I hope this helps?
Cor
\\\
Private Sub Form1_Load(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
Dim file As String = "Test2.txt"
Dim path As String = "C:\"
Dim ds As New DataSet
Try
Dim f As System.IO.File
If f.Exists(path & file) Then
Dim ConStr As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
path & ";Extended Properties=""Text;HDR=No;FMT=Delimited\"""
Dim conn As New OleDb.OleDbConnection(ConStr)
Dim da As New OleDb.OleDbDataAdapter("Select * from " & _
file, conn)
da.Fill(ds, "TextFile")
End If
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try
End Sub
///
P
Paul Clement
¤ Hi,
¤ How do I pharse a CSV file and send the data to a database. This file is hugh.
¤
Additional info would help. What kind of database do you want to import the file to?
Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
¤ How do I pharse a CSV file and send the data to a database. This file is hugh.
¤
Additional info would help. What kind of database do you want to import the file to?
Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
P
Paul Clement
¤ SQL Server
Since it is a rather large file I would create a DTS package and run it from VB.NET or C#:
HOW TO: Use DTS Package Events in Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;321525&Product=vbNET
Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
Since it is a rather large file I would create a DTS package and run it from VB.NET or C#:
HOW TO: Use DTS Package Events in Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;321525&Product=vbNET
Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)