How to Import ms access 2007 data into sql server table

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

How to import all or specific columns from ms access 2007 database table into sql server existing table through code in asp.net c#.

Posted 30-Aug-15 18:40pm

xpertzgurtej

Updated 30-Aug-15 18:42pm

v3

Add a Solution

Comments

PIEBALDconsult 31-Aug-15 0:53am

Why would you even consider using ASP.net?
If you do it a lot, you should look into SSIS or another ETL package.

xpertzgurtej 31-Aug-15 1:00am

actually i have to implement this functionality in asp.net because i am using asp.net and sql server in my project and want to import access data into my sql server table

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)

Wendelius · Answer 1 · 2015-08-30T19:08:00

Solution 1

In short, why note read the data from Access to a dataset using a OleDbConnection[^] and OleDbDataAdapter[^] and the from the dataset insert the data from the dataset to the SQL Server table via SqlConnection[^] using SqlBulkCopy.WriteToServer Method (DataTable)[^]

Posted 30-Aug-15 19:08pm

Wendelius

Comments

xpertzgurtej 31-Aug-15 2:19am

Thanks for your reply..But is there any direct running example as per my requirement?

Wendelius 31-Aug-15 2:44am

I would think there are a lot of examples for each step. For example have a look at C# / VB.NET / C++ CLI: Create, read and write MS Access (mdb, accdb), MySQL, SQL Server, SQL Server Compact and SQLite databases[^]

Maciej Los 31-Aug-15 2:24am

5ed!

Wendelius 31-Aug-15 2:44am

Thank you Maciej!