Click here to Skip to main content
15,670,482 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how to upload a csv file to sql server 2005 via
upload from different csv file

1 solution

First convert your csv file to DataTable, For your reference find the below codes.

Private Function CSVtoDataTable(ByVal filepath As String) As DataTable
       Dim sr As New StreamReader(filepath)
       Dim f As File
       Dim fval As String()
       Dim dt As New DataTable
       Dim dr As DataRow

       sr = f.OpenText(filepath)

       fval = sr.ReadLine().Split(",")

       For i As Integer = 0 To fval.Length - 1
           dt.Columns.Add(New DataColumn(fval(i).ToString()))

       dr = dt.NewRow

       While sr.Peek() <> -1
           fval = sr.ReadLine().Split(",")
           dr = dt.NewRow
           For i As Integer = 0 To fval.Length - 1
               dr.Item(i) = fval(i).ToString()

       End While

       Return dt

End Function

Then insert the datatable's records to the sql table using SqlBulkCopy method. Refer my tips from the following url

SQL Bulk copy method to insert large amount of data to the sql database[^]

Hope this will help you,

Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900