Hi all,

Every month, I need to archive large datasets (~400,000 records) from Access to SQL Server. Doing an append query via linked table is awfully slow.

I wanted to see what the most efficient / easiest way to do this?

Any help is appreciated.