Sub СозданиеТаблицы()
Dim connDB As Object
Set connDB = CreateObject("ADODB.Connection")
connDB.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; data source=" & "G:\3\A.accdb"
connDB.Open

connDB.Execute = "CREATE TABLE RRR" & "(ID  COUNTER, Дата DATETIME, Вася TEXT, Петя TEXT,Маша TEXT,Балл TINYINT,Я TEXT);"
connDB.Close
Set connDB = Nothing
End Sub

Sub Insert()
Dim connDB As Object
Dim sss As String
Dim ddd As String
sss= "Кошка"
ddd= "Мышка"


Set connDB = CreateObject("ADODB.Connection")
connDB.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; data source=" & "G:\3\A.accdb"
connDB.Open


connDB.Execute = "INSERT INTO RRR VALUES( Cells(1,1).Value , sss, ddd)"
connDB.Close
Set connDB = Nothing
End Sub

,'" & m & "')