28,409
社区成员




Set conn = CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\AA.mdb;"
sql = "UPDATE tbl SET [date]=#2009-08-23# WHERE [date] IS NULL
conn.Execute sql
sql = "UPDATE tbl SET [user]='YYY' WHERE [user] IS NULL
conn.Execute sql
conn.Close