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

Question

I need to insert records from source MS Access database table to another MS Access database table (Destination database).both tables are from different ms access database files and contains same fields.

i'm writing the code using vb.net 2003 windows application with MS Access 2003 database.

I don't know how to connect two tables using connection string.so waiting for ur valuable information on how to achieve this task.
thanks in advance
have a pleasant day

regards
chandru

CHANDRASHEKAR B · Answer

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

Muhammad Shahid Farooq · Answer

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.

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

Answers (2)