Insert Fields into a table

[ltlearn]

I am using ADO accessing the Access 2000 database. How do I insert a field into a table ?
Thanks.

[nullus]

two ways

1. Use a recordset

Dim rstAddRecord As ADODB.Recordset
Set rstAddRecord = New ADODB.Recordset
 
rstAddRecord.Open "Table1", con, adOpenKeySet, adLockOptimistic
rstAddRecord.AddNew
  rstAddRecord!Field1 = "blah"
  rstAddRecord!Field2 = "dfgffg"
  'etc.
rstAddRecord.Update
rstAddRecord.Close

2. Use SQL

Dim strSQL As String
 
strSQL = "insert into table1 (Field1, Field2, Field3) values ('blah', 'dfgfdg', 'ertretr')"
 
con.Execute strSQL