How to import data from access database to sql server 2008 using C#

Question

0.00/5 (No votes)

See more:

, +

Hello
I want to import data from access database to sql server 2008 using c#.
With some validation means,
In Access we have varchar(10) and sql we have varchar(11) then not allow to import data. like vise if name is not match of the column than also not allow to import.

Thanks

Posted 30-Dec-12 22:01pm

Abhimanyu Rawat

Updated 30-Dec-12 22:04pm

WajihaAhmed

v2

Add a Solution

Comments

Gordon Beeming 31-Dec-12 4:48am

You'd need to do a scheam compare and then setup the data sync only for tables/colums that match.

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)

Sampath Kumar Sathiya · Answer 1 · 2012-12-30T23:01:00

Solution 1

Hi,

Using SQL Server DTS you can do the above.

Execute SQL Server 2005 Integration Services package from C#[^]

Posted 30-Dec-12 23:01pm

Sampath Kumar Sathiya

Kalyan_A · Answer 2 · 2012-12-30T23:55:00

There is a tool provided by Microsoft for the same.
below are instructions i put-up for someone else.

1. Download link for the tool -
http://www.microsoft.com/en-us/download/details.aspx?id=28763[^]

2. Download the license key to enable the tool.
http://www.microsoft.com/download/en/details.aspx?id=18589[^]

3. Launch the downloaded tool and specify the location of the license key downloaded in step 2

4. follow the wizard to transfer the objects from Access to SQL Server#

I tried with a small MDB at my end and it was straight forward.
Hope this helps.

Cheers