Situation:
I have a Sql Server in Rome and a shared server dir (with the access database) on a Server in New York.

I have permission on sever dir and databse.

The database on sql Server have exactlly the same structure of Access database. (the table on Sql Server have 200.000 records and 48 columns).

Now i want to recopy all records from Rome to NewYork.

Wath is the best way in terms of time to recopy records from Sql Server to acces Table?

note:
I want to use in my app the ADO jET drive.