Hi, I have created a linked server for an MS Access table. I now need to copy the records from the linked server table to my SQL database table. The # of records are 100,000. If I use a simple Insert Into (Select * from linked server), the query executes for almost 10 minutes. Is there a way to speed this up ?