If you have a CSV file from which you want to import the data into the database and the CSV file has a column which contains values separated by multiple commas, you cannot extract the data by using the Split() function. That is because of the fact that the number of values you get will be more than the number of columns present in the file. So by creating a OleDBConnection you can get the whole data from the CSV file into a datatable. The following snippet of code will give you the datatable if provided the path of the file name. You can also save the file on the server and use the file for extracting the data into a datatable. Finally, you can also import the data from the datatable .
Public Function GetDataTable(ByVal strFileName As String) As DataTable
'Create the connection string to take the data from the CSV file to a datatable
Dim strConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & System.IO.Path.GetDirectoryName(strFileName) & ";Extended Properties='text;HDR=Yes;FMT=Delimited'"
Dim objConn As OleDb.OleDbConnection = New OleDb.OleDbConnection(strConnectionString)
Dim dtPeople As DataTable = New DataTable
Dim objCmdSelect As OleDb.OleDbCommand = New OleDb.OleDbCommand("SELECT * FROM [" + System.IO.Path.GetFileName (strFileName) + "]", objConn)
Dim objAdapter1 As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter()
objAdapter1.SelectCommand = objCmdSelect
'Return the datatable