How Do I Delete Rows With Query On Database Excel Vb 10

See more:

VB

VB10

MS-Excel

database

, +

hi all, i have an annoying problem here..
i want to delete selecting rows on my datagridview with connect to excel, but it show message like this "deleting data in a linked table is not supported by this ISAM", any sugestion, help me please

here my code :

'for connect
Dim connstring = "provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Application.StartupPath & "\datakaryawanall.xls;Extended Properties=Excel 8.0;"
Public myDate As Date

'delete button
 Try
            Dim SqlQuery As String = "DELETE * from [datakaryawanall] where NIK ='" & txtNIK.Text & "'"
            Dim SqlCommand As New OleDbCommand
            With SqlCommand
                .CommandText = SqlQuery
                .Connection = cn
                .ExecuteNonQuery()
            End With
            MsgBox("Satu Data Karyawan Sudah diHapus")
            Me.RefreshDataView()
            Me.bersih()
        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try

or help me building query that make all of cell in the row has no value, and when load datagridview not read the blank value, is it possible ??