Copying MS access table in C#?

Question

1.00/5 (1 vote)

See more:

Hi,

I want to copy selected MS-Access database table in new access database table.
My application is having check-boxes to select table name to copy from access database and on selection i need to create new access database (.mdb) file and copy particular selected tables from old database to newly created database.

How can I do this?

Please help me...

Thanks...

What I have tried:

I have tried code to create access database but it is not sufficient. I don't know how to copy only table with it's structure from old to new one.

Posted 8-Nov-16 19:07pm

virus131

Updated 8-Nov-16 19:37pm

Add a Solution

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)

Mycroft Holmes · Accepted Answer · 2016-11-08T19:37:00

Solution 1

Google[^] gives you details how to get the table definitions from Access.

Then you create a connection to your new MDB and create the tables.

OR

Copy the source MDB, make a connection to it and drop the table that are NOT selected.

Then delete the data from the tables in the new MDB.

Posted 8-Nov-16 19:37pm

Mycroft Holmes

Comments

virus131 9-Nov-16 3:43am

Thank you for solution... Will try this.