Click here to Skip to main content
14,384,168 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hi everyone
I have to make a application to sync data from my Online SQL server database to local MS Access(.mdb) database. For this I am reading records from SQL server into datatable and inserting these records one by one using loop to the local database but it takes lot of time.
Can anybody help me in doing this task in a better way

This data sync has to be done on button click because I have to distributed the application to different computers across the state.

thanks in advance

What I have tried:

'MyDataSet is a function which return Records from Online SQL Server
        Ds = MyDataSet("Select * from AllCases " , "O")
        
        For i = 0 To Ds.Tables(0).Rows.Count - 1
              InsertStatement()
        Next
Posted
Updated 2-May-19 20:55pm
v3

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

This is not an exact answer, but - i hope - a bit useful information...
MS Access is able to connect to MS SQL Server, see: Import or link to data in an SQL Server database - Access[^]

You may want to use method described here: vb.net - DataTable to Access Database Table | DaniWeb[^]
   
Comments
ukag 3-May-19 13:41pm
   
Hi It shows the error "The DataAdapter.SelectCommand property needs to be initialized"
ukag 3-May-19 15:17pm
   
Pl Help me to complete this task

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100