How to copy access database tables to another access database in C#

Question

0.00/5 (No votes)

See more:

Im working on a winform application using c#.
Im using access database for it.
I want to make a browse button to select my old db, then after click a button, copy all of its tables(selected database) and data to my project new database and dosnt remove tables that exist in main database.
1.I wanna know how to make a connection string to selected old database(that I selected with browse)
2.how to make query to copy all of its tables and data to my new database(directory database).
**all tables have the same name and columns.
thanks

What I have tried:

I cant figure it out how to make a connection string to browsed database and how to write a query to copy its tables to another database

Posted 12-Oct-22 11:20am

Ehsan Nabavi

Updated 12-Oct-22 17:56pm

Add a Solution

Comments

Sandeep Mewara 12-Oct-22 23:01pm

Google has ample information around this. Did you look at them? Anything specific you are stuck with?

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)

OriginalGriff · Answer 1 · 2022-10-12T17:56:00

Quote:
1.I wanna know how to make a connection string to selected old database(that I selected with browse)

Simple SQL Connection String Creation[^] - use the "Provider" tab to select the Access DB engine and it works for Access DBs as well.
Then you can import that string into your app, and replace the DB path part with the path the user selected.

Quote:
2.how to make query to copy all of its tables and data to my new database(directory database).
**all tables have the same name and columns.

c# copy table from one database to another access - Google Search[^]

Quote:
is not gonna work cuz he wrote the address "Z:\Docs\first.accdb"
I dont have a address

:sigh:

You replace the path in your example: "Z:\Docs\first.accdb" with a unique marker: "%PATH%" say.

string conPattern =
@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%PATH%";

You browse.
It returns a path string.

You replace the marker with the string he browsed to.