==[[Access VBA レコードの挿入]]==[[Access ]] 2000
Public Sub insertData()
Dim conn As ADODB.Connection
Dim rec As ADODB.Recordset[[R]]ecordset
Set conn = CurrentProject.Connection
Set rec = New ADODB.Recordset[[R]]ecordset
Call rec.Open("NewTableName", conn, adOpenKeyset, adLockOptimistic)