suggestion to copy data from Sql Server into Access database

[sal21]

Scenario:
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 table on sql Server have exactlly the same structure of Access table. (in the table on Sql Server are 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 drive.

[sal21]

sorry for up!:-)

[Orjan]

is this a one time thing, or will it need updating?

for a one time thing, I'd import it through access built in system via odbc.
well, you can actually link the sql server table into access directly if you like.

[rabihtawil]

This is rather easy & can be done if you follow the steps i did in this video

[YOUTUBE]_ih1eqEtt44[/YOUTUBE]