How to import data from csv file to datagrideview in vb.net.

See more:

VB

I am using the below code to import data from excel file to datagrideview .

I want to import data from CSV file to datagrideview . getting error "Exter table is note in the expected format"

How to import csv data file to datagridview

What I have tried:

Private Sub ButBhav_Click(sender As Object, e As EventArgs) Handles ButBhav.Click
Dim cn As OleDbConnection
Dim cmd As OleDbCommand
Dim da As OleDbDataAdapter
Dim dt As DataTable
da = New OleDbDataAdapter
dt = New DataTable

OpenFileDialog1.Title = "Please select Save file"
OpenFileDialog1.InitialDirectory = "D:\Test"
'OpenFileDialog1.Filter = "Excel|*.xls|All Files|*.*"
OpenFileDialog1.Filter = "Excel|*.csv|All Files|*.*"
If OpenFileDialog1.ShowDialog() = DialogResult.OK Then
Dim Filepath As String = OpenFileDialog1.FileName

cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Filepath & ";Extended Properties='Excel 8.0;IMEX=1;HDR=Yes;'")
cmd = New OleDbCommand("Select * from [abc$]", cn)
da.SelectCommand = cmd
da.Fill(dt)
DgvImport.DataSource = dt
End If
End Sub