1. Forums
  2. Programming
  3. Visual Basic 6.0
  4. suggestion to copy data from Sql Server into Access database

suggestion to copy data from Sql Server into Access database

Submitted by sal21 on
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 note: I use in my app the ADO jET drive.