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.
You can export all the record from SQL Server to MS Access easily by using the following steps.
1. Go to SQL Server Enterprise Manager if you are using a management tool.
2. Locate the database.
3. Right click the database.
4. Click All Tasks.
5. Click Export Data.
From there on follow the wizard. Be sure to select MS Access as your data source.
Tks but i need all with ado and vb classic.:-)
Tks for patience
Yes tks but i need all with vb6 and ado jet, is possible?
Tks for patience.
Yes of course it is possible.
ok... but naturaly i nedd example code, hvae one?
Tks.
I'm confused. As what you have said you need only to copy data from SQL Server to MS Access.
Hi friend sorry for my terrible english, but i'm italian from Napoli:-)..
Really i need a code in Vb6 with ADO to make the operation.
Please answer my question so I can help you.
Pages
Add new comment