How to insert Msacess Database to Sqlserver Database

Question

0.00/5 (No votes)

See more:

Dear Friends,

Here i want to import MsAcess Database to sqldatabase using Asp,net with C#.Please provide Some Suggestions.
But i want in Asp.net with c# Means through FileUpload Concept i will Upload the Msacaess Database and I will take Import Button.From this Button i should convert msacess database to sqlserver database.This Should be done through coding Only.

Regards,

Anilkumar.D

Posted 1-Sep-11 22:48pm

Anil Honey 206

Updated 1-Sep-11 23:19pm

v3

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)

Abhinav S · Answer 1 · 2011-09-01T22:57:00

Solution 1

Did you do a search on the internet?

Here are the top 3 search results -

http://support.microsoft.com/kb/237980[^]
http://cfpayne.wordpress.com/2006/07/23/how-to-import-microsoft-access-into-sql-server-2005/[^]
http://geekswithblogs.net/tewissler/archive/2006/08/15/88077.aspx[^]

Posted 1-Sep-11 22:57pm

Abhinav S

Updated 1-Sep-11 22:58pm

v2

Comments

Anil Honey 206 2-Sep-11 5:18am

But i want in Asp.net with c# Means throgh FileUpload Concept i will Upload the Msacaess Database and I will take Import Button.From thie Button i should convet msacess database to sqlserver database.This Should be done through coding Only.

Abhinav S 2-Sep-11 5:31am

In this case, you might want to fetch data from MS Access and insert them into similar tables that have been created on the SQL Database.
Another way could be to look at the Microsoft.SqlServer.Dts.Runtime Namespace.

Anil Honey 206 2-Sep-11 5:41am

Yes what u said is correct in Coding Iam not Getting Logic

Abhinav S 2-Sep-11 6:20am

Try searching on the internet for some samples.