Its not really any harder than DAO. I mean it is a bit diferent, but if you can do DAO, you can do ADO. i think the only major difference is the settting up of a connection string that tells teh engine what type of database it is, the location of the database file, and any login stuff. This isnt reallt accurate but it wold look something like this

dim rs as ADODB.REcordset
Conn = "Driver=Access;Database="c:\mydb.mdb";userid='me';pass='sa'"

SQL = "Select * from mytable"

Set RS = New ADODB.Recordset
rs.open sql,conn


And thats sort of how you would do it. Off the top of my head so this isnt quite correct, but it is enough to give you an idea.

After that it is the same

rs!fieldname = "something"
rs.addnew
rs.udate
etc.