How to transfer CSV content to MS SQL Table

How can I transfer the contents of a CSV file to MS SQL Table?

I have made a connection string but I don’t know how to proceed..

Dim xConnStr As String = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\;Extended Properties=”txt;HDR=Yes;FMT=Delimited”;”