Merge 2 table data with same structure

Question

1.00/5 (1 vote)

See more:

Hello ALL,

I have table1 in database1.mdb with some records, and table2 in database2.mdb with some records. The data structure of table1 and table2 is same. Now i need to insert records from table2 in table1. How can I do this?

I have been trying the ms-access import options but it creates a different table in database1.mdb with records of table2. But I want all the records from table2 in table1.

Posted 30-Jun-11 20:53pm

Uday P.Singh

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

jerrykid · Answer 1 · 2011-06-30T21:06:00

Solution 1

INSERT into table1
SELECT * FROM table2

Hope this help

Posted 30-Jun-11 21:06pm

jerrykid

Updated 30-Jun-11 21:09pm

v2

Comments

Prerak Patel 1-Jul-11 3:09am

OP uses different access files.

Uday P.Singh 1-Jul-11 3:13am

the table1 and table2 does not exists in same file.(but the name and structure of 2 tables are same).

Member 8043849 · Answer 2 · 2011-06-30T23:07:00

primary key may create problem
anyway u can get the data from 2nd table 1 by one and insert it to the other table.

use dataadapter concept.

i provide u the sample implement it in yours.
Do not copy paste but write your own as u will get suggestion from VS Intellisense.

understand it and then implement it.
// query select * from table 1
// query2 select * from table2

<code>
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString());
SqlDataAdapter da;
SqlCommand cmd;

Datarow dr;
//for 1st table
da = new SqlDataAdapter (query,con);
DataSet ds1 = new DataSet();
da.Fill(ds1);

//for 2nd table
da = new SqlDataAdapter (query2,con);
da.Fill(ds1);

foreach (DataRow dr2 in ds1.Tables[1].Rows)
{
dr=ds1.tables[0].newrow();
dr[0]=dr2[0];
dr[1]=dr2[1];
//similarly for other columns

ds1.tables[0].rows.add(dr);
}

//now update it to database
cmd=new sqlcommandbuilder(da);
da.update(ds1);

dr=ds.tables[0].newrow();

</code>