A couple of examples (one via ADO, the other using DAO); with ADO, you are limited to creating the table via an SQL statement, whereas DAO allows you to play with the Access data object ...