To excel the last row and then add a record, the following code
Private Sub Command4_Click ()

Dim SQLSTR As String
SQLSTR="select * from [sheet1 $]"
Adodc1. RecordSource SQLSTR=
Adodc1. Refresh
Adodc1. You. MoveLast
Adodc1. You. AddNew
Adodc1. You. Fields (0)=90
Adodc1. You. Fields (1)=78
Adodc1. You. Fields (2)=79
Adodc1. You. Update
Adodc1. Refresh
The Set DataGrid1. The DataSource=Adodc1
DataGrid1. Refresh

End Sub
But the runtime produces the following error


Can use SQL statements to add excel in vb, query, delete operations such as
Use addnew, update method to excel operate?
I want to use ado to access to excel, carried out on the table to add, query, delete operations, like SQL code to write, if you can, how to write, can't, the use which kinds of method, thank you