vb.net - Extract data from one table to anoher -

i have main database. extraction data datatable , need update private database data avoiding doubling. when use update command, data doubling in private database, in case of fill nothing happens @ all.

here code:

dim table new datatable cn = new oledbconnection("provider=microsoft.jet.oledb.4.0;data source=c:\main.mdb;jet oledb:database password=123") cmd = new oledb.oledbcommand {.connection = cn} cn.open() cmd.commandtext = "select * catalogue" da = new oledbdataadapter(cmd) da.acceptchangesduringfill = false da.fill(table) da.dispose() cn.close() '-------------- cn = new oledbconnection("provider=microsoft.jet.oledb.4.0;data source=private.mdb;jet oledb:database password=123" cmd = new oledb.oledbcommand {.connection = cn} cn.open() cmd.commandtext = "select * catalogue" da = new oledbdataadapter(cmd) mybuilder = new oledbcommandbuilder(da) da.fill(table) 'add no data da.update(table) 'doubling data da.dispose() cn.close() 

as understand, when talk doubling data, it's mean have data in private database , can same data in main database.

problem visualization:

begining

main database, table 1 data  1  2  3  private database, table 1 data  1  2 

ending

what need:  private database, table 1 data  1  2  3  get:  private database, table 1 data  1  2  1  2  3 

sad here no replies notification. solved problem recommendation other forum. it's needed read main database, client , @ end merged. duplicated records removed.