All,

I want to add a whole recordset to a table without having to add one record at a time, is this possible?

thanks,

You can use an sql INSERT INTO statement and either specify a value list or a select statement to append from another table.