Insert Records from an ms access table to other(2nd) existing ms access table using .net

Good Morning Muhammad,

Thanks for your reply.Actually i thought of doing the same..i.e., import to dataset and export to destination database.the problem is apart from source fields..i need to update someother fields of destination database with some values..but i don't know how to use 2 connections for connecting 2 database tables and do the data manipulation.so it wil be immense help if u can show me the code for doing this task.if it is vb.net code it is more helpful(but csharp code is also ok).

Thanks in Advance

have a plesant day

regards

chandru

Create two connections, one for source database and second for destination database.

Then fill the dataset from source database

Then read the field values from dataset using for loop and insert into the desitnation datbase.