1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
OpenFileDialog1.ShowDialog()
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
Dim DtSet As System.Data.DataSet
Dim filePath As String = OpenFileDialog1.FileName
Try
Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & filePath + ";Extended Properties=Excel 8.0;"
Dim connection As OleDbConnection = New OleDbConnection(connectionString)
Dim nomFeuil As String = InputBox("Entrer le nom de la feuille excel", , "Feuil1")
Dim cmdText As String = "SELECT * FROM [" & nomFeuil & "$]"
Dim command As OleDbCommand = New OleDbCommand(cmdText, connection)
MyCommand = New System.Data.OleDb.OleDbDataAdapter(cmdText, connection)
DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet)
DGV.DataSource = DtSet.Tables(0)
Catch ex As Exception
MsgBox(ex.Message, 0 + vbExclamation, "Erreur Importation Excel")
End Try |
Partager