Merge multiple Access database into one big database with c# code

Question

1.00/5 (1 vote)

See more:

I have multiple Access 2007 databases (accdb files) that are identical and i want to merge them into one using windows form using c# code but i don't know how to do it because i'm a beginner in c#?

Posted 18-Mar-13 10:48am

pouroutis

Add a Solution

Comments

[no name] 18-Mar-13 16:54pm

"but i don't know how to do it because i'm a beginner in c#?", if that is your question then the answer is probably "yes". Otherwise you are going to want to research connecting to Access databases and using the "INSERT INTO" SQL statement.

Sergey Alexandrovich Kryukov 18-Mar-13 17:02pm

This is not a well-formed question at all (I am not talking about it's validity, not even well-formed). So the correct answer, is you will, would be "42". :-)
—SA

pouroutis 18-Mar-13 17:10pm

database are identical but i want to keep all data into one because all datatables have only one or two rows because i use access form for questionnaires from different students in my university and they sent me their answers in database table so i must open all files one by one and i want to greate a windows form application because i am going to take some results from the answers and use the results for future presentations .

[no name] 18-Mar-13 17:14pm

So go ahead and do that. There is nothing stopping you. That still does not change the fact that you will have to do some research on how to connect to a database and execute queries. No one here is going to write all this code for you.

Sergey Alexandrovich Kryukov 18-Mar-13 17:18pm

Right. And I even added my answer to it. :-)
—SA

pouroutis 18-Mar-13 17:13pm

my question is how can i merge the databases into one with c# code??

[no name] 18-Mar-13 17:16pm

You connect to the database, query the data in one database and insert it into the other database.

Sergey Alexandrovich Kryukov 18-Mar-13 17:19pm

5!—SA

1 solution

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2013-03-18T11:05:00

Solution 1

Please start here: http://bit.ly/XV6ccH[^].

I'm pretty much sure that some posts you can find this way are written by experienced authors, not beginners. :-)

—SA

Posted 18-Mar-13 11:05am

Sergey Alexandrovich Kryukov

Updated 18-Mar-13 11:17am

v2

Comments

pouroutis 18-Mar-13 17:15pm

my question is how can i merge the databases into one with c# code??

Sergey Alexandrovich Kryukov 18-Mar-13 17:17pm

Got it. I modified my answer. Please try again. :-)
—SA