I want to append records to a table using the ADO Recordset. I create my recordset with SELECT * FROM Tablename. The problem is this retrieves all the records before I can do my AddNew's and some tables are massive! How can I do this without retrieving any records? How do you use the "Append-only Rowset" property?