import csv file in sql table

[Guest]

Hi,

I'm trying to import data from csv file into a sql table. this is how i read
the information from the file:

=============
Private Sub import_oledb()
da_import.Fill(Ds_import_u)

Dim strPath As String = "c:\test.csv"

Dim ds As New DataSet
Try
Dim f As System.IO.File
If f.Exists(strPath) Then
Dim ConStr As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
"c:\" & ";Extended Properties=""Text;HDR=No;FMT=Delimited\"""
Dim conn As New OleDb.OleDbConnection(ConStr)

Dim da As New OleDb.OleDbDataAdapter("Select * from " & _
"test.csv", conn)
da.Fill(ds, "test.csv")

End If
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try

DataGrid1.DataSource = ds.Tables(0)

End Sub
=============================
Now, this fills the ds and binds the datagrid. how do i dump all these rows
in a table in sql database?

I would appreciate any help.

Thank you,
Catalin

 

[Guest]

Hi

There is much fast way to bulk insert file content directly to table in
database:

command.CommandText = "BULK INSERT db_table_name FROM 'c:\test.csv' WITH
(DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\n')"

command.ExecuteNonQuery()

HTH

Elton Wang
(e-mail address removed)

 

[Val Mazur \(MVP\)]

Hi,

You could use BULK as Elton suggested, but if you still need to use
dataSets, then check next KB with an example

http://support.microsoft.com/default.aspx?scid=kb;en-us;316244

 

[Guest]

thanks for the replies. yes, i'll be using bulk insert instead of datasets.