AspdotnetCodes.com
Search
Articles
Books
Resources
Asp.Net News
Downloads
Free Tech Magazines
Asp.Net Web Hosting
Archives
Softwares
Newsletter
Suggest Us
Link to Us
Feeds Subscription
Articles
Questions & Answers
Tips & Tricks
 Importing data from MS Access to SQL Server 2005
Posted by Raman Pundir on  1/28/2009 12:01:38 AM Category: Asp.Net 2.0
Add to my favorites
Email to friend
hi all,
i need to import data coming from 13 different location in MSAccess database format. For that i have to develop an application wheather web or window so that i can import that data into sql server 2005.
Any suggestion or solution will be appreciable a lot.

thanx and regards
Raman

Post Your Reply Post New Question

 Viewer's Reply
Importing data from MS Access to SQL Server 2005
Answered By Kunwar on 3/4/2009 4:57:13 AM
you can do so using either windows or web application.
To export Data from MsAccess you need to create Two ConnectionString Each pointing to different DataBase

ConStr_Access- will point to MS Access DataBase
ConStr_Sql will point to SQL Database

Once this is accomplished, you can easily create dataAdapter and then populate the DataSet. Once you have data in DataSet you can insert it back to SqlServer.

If you can make use of SQLBulkCopy for Exporting data it will be much faster.

Other option is making use of Import/Export Wizard.

From Kunwar
http://KpratapS.blogspot.com
 
Post Your Reply If you still have problem, post it again under this reply for better response.

 
Sponsored by
FierceDeveloper
Simply JavaScript - Free 150 Page Preview!
Run Your Own Web Server Using Linux & Apache - Free 191 Page Preview