Question

Access中，如何将Form中Text的值传递给Table里？

最好给出VBA格式的代码，多谢

Answer 1

Dim con as NEW ADODB.Connection
con.open"Privader=SQLOLEDB;....."
con.Execue "Insert into Table1(Cloume1) values('" & Text1.Text & "')"
con.Close
set con=Noting