I am having trouble with the following code. I want to import CSV data into a sql table. The code I am using is the following:

Code:
] Private Sub IMPORTHISTORIESToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles IMPORTHISTORIESToolStripMenuItem.Click
        Dim dt As New DataTable()
        Dim line As String = Nothing
        Dim i As Integer = 0

        Using sr As StreamReader = File.OpenText("C:\Users\Administrator\Desktop\SKEDULERING\EZY Wine Data\skedp_lb.csv")

            line = sr.ReadLine()


            Do While line IsNot Nothing
                Dim data() As String = line.Split(","c)
                If data.Length > 0 Then
                    If i = 0 Then
                        For Each item In data
                            dt.Columns.Add(New DataColumn())
                        Next item
                        i += 1
                    End If
                    Dim row As DataRow = dt.NewRow()
                    row.ItemArray = data
                    dt.Rows.Add(row)
                End If
                line = sr.ReadLine()
            Loop
        End Using

     


        Dim SqlconnectionStringBlokkeklaar As String = "Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Administrator\Desktop\SKEDULERING\Skedulering6\Skedulering6\SkeduleringsDatabasis6.mdf;Integrated Security=True"

        Using connection As New SqlClient.SqlConnection(SqlconnectionStringBlokkeklaar)

            connection.Open()
            Using copy As New SqlBulkCopy(connection)
                copy.ColumnMappings.Add(0, 0)
                copy.ColumnMappings.Add(1, 1)
                copy.ColumnMappings.Add(2, 2)
                copy.ColumnMappings.Add(3, 3)
                copy.ColumnMappings.Add(4, 4)
                copy.ColumnMappings.Add(5, 5)
                copy.ColumnMappings.Add(6, 6)
                copy.ColumnMappings.Add(7, 7)
                copy.ColumnMappings.Add(8, 8)
                copy.ColumnMappings.Add(9, 9)
                copy.ColumnMappings.Add(10, 10)
                copy.ColumnMappings.Add(11, 11)
                copy.ColumnMappings.Add(12, 12)
                copy.ColumnMappings.Add(13, 13)
                copy.ColumnMappings.Add(14, 14)
                copy.ColumnMappings.Add(15, 15)
                copy.ColumnMappings.Add(16, 16)
                copy.DestinationTableName = "Ontledings_Vyfjaar_Histories"
                copy.WriteToServer(dt)
            End Using
        End Using




    End Sub
When I do the sqlbulkcopy I get the following error : The given value of type String from the data source cannot be converted to type date of the specified target column.

My problem lies with column 10. In my database table it is of type date. In the data table(dt) it is enclosed in double quotes. I presume it is seen as an string. Can someone please help me understand what I am doing wrong with the sqpbulkcopy and possibly my perception of column mappings?

Regards