How to export data from Access to SQL server, from an "Export" button on web page?

Posted on 2005-03-28
Medium Priority
Last Modified: 2010-04-07
Hello experts,

I need to create a button on my asp.net web page which will take the data from a table in MS access database (on the hard disk or a cd or a floppy) and export it to a table in SQL server 2000 database. Both the tables have the same fields etc.

I have no clue how to go about it. Can anyone guide me in the right direction and tell me how to do this?

Thanks a lot.
Question by:jaiswalpragya
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 33

Accepted Solution

raterus earned 1000 total points
ID: 13648485
Use DTS, I've actually explained it somewhat on another question I'm involved with right now,

Author Comment

ID: 13665101
Thanks for the reply. But I am not fully aware of the DTS concepts. Is it possible that I get the data from access table in a dataset and then loop through it to insert it in sql server database?


Expert Comment

ID: 13671565

agree with raterus idea. DTS is the best method to export data from any database including access to sql server.  You can create database in sql using DTS Wizards and select whatever tables you want exports to sql server, their field types etc.  

If you have an already database in sql server(for your access database), you can export data to that database too using DTS. It is very flexible.


Assisted Solution

ayha1999 earned 1000 total points
ID: 13671586

for using DTS just go to "Import and Export data" section in sql server menu and follow the instructions.

hope this helps.


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question