sorry,应该是
Private Sub Command1_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sql As String
Dim a(1) As Date
a(1) = CDate(Now)
'MsgBox a(1)
cn.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=sale"
' sql = "select time from ys"
'Set rs = cn.Execute(sql)
'MsgBox rs(0)
' rs.Open cn, 1, 3
sql = "insert into ys(time) values ( '" & a(1) & "')"
cn.Execute (sql)
'rs.AddNew
'rs.Fields(0) = CDate(Now)
'rs.Update
'rs.Close
'Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub
Private Sub Command1_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sql As String
Dim a(1) As Date
a(1) = CDate(Now)
'MsgBox a(1)
cn.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=sale"
' sql = "select time from ys"
'Set rs = cn.Execute(sql)
'MsgBox rs(0)
' rs.Open cn, 1, 3
sql = "insert into ys(time) values ( '" & a(1) & "')"
cn.Execute (sql)
'rs.AddNew
'rs.Fields(0) = CDate(Now)
'rs.Update
'rs.Close
'Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub
sql = "insert into ys ([time]) values ( " & a(1) & ")"
另外,最好不要用关键字,保留字作为字段名。