Question

请问一下如何用VB给EXCEL的表中添加记录 用ADO

如题我的代码发给大家
添加按键的代码：
Private Sub addbttn_Click()
addbttn.Visible = 0
delbttn.Visible = 0
editbttn.Visible = 0
okbttn.Visible = -1
cancelbttn.Visible = -1
Adodc1.Recordset.AddNew
Text1.SetFocus
End Sub
确认按键的代码：
Adodc1.Recordset.----（这里应该填什么？我填update不能运行）
Command1.Visible = -1
Command2.Visible = -1
command3.Visible = -1
Command4.Visible = 0
Command5.Visible = 0
还有就是
Adodc1.Recordset.AddNew
中间添加语句，请问添加什么语句？
Adodc1.Recordset.Update

Answer 1

Private Sub addbttn_Click()
addbttn.Visible = 0
delbttn.Visible = 0
editbttn.Visible = 0
okbttn.Visible = -1
cancelbttn.Visible = -1
Adodc1.Recordset.AddNew
Text1.SetFocus
End Sub
确认按键的代码：