My users get much better performance running a report that uses tables linked to an Access Backend than they do from SQL Server. However, all the data is maintained on SQL Server. I would like to have a VBA script that copies selected tables from SQL Server to an Access Backend at the beginning of the day and then have the users reference the tables on Access for performance. I am currently using an Access query to append the data to an empty Access table successfully. However, it takes about 5 minutes to load all the tables this way. Is there a faster way to do this? The temp tables have no keys or indexes since they don't ever get updated. Would creating an ADO Recordset be faster? Is there a way to do a "bulk" load? Thanks, Eddie