You can use ADO to create tables and the only way is using SQL.
Set cat = New ADOX.Catalog
cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDB_Path & ";"
'create the table
Set tbl = New ADOX.Table
tbl.Name = "tblName"
tbl.Columns.Append "ID", adInteger
tbl.Columns.Append "Field1", adVarWChar, 60
cat.Tables.Append tbl
Set cat = Nothing
CREATE TABLE tblName (
ID Primary Key Not Null,
Field1, Text(60));
I don't see why my post isn't clear.
You asked if you can use ADO to create tables etc using SQL, I said yes.