TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Dong Liu
NA
3
0
Copy a table from Access to SQL Server
May 18 2005 10:27 AM
I tried to copy a table from Access to SQL Server through ADO.NET. I thought .Net should have a class or a function in Class like OleDbDataAdapter to do it with one single call. I could not find out such an approach in .Net built in functions. The first manual approach I tried is using OleDbDataAdapter's fill function to get the DataTable from Access and then employing SqlDataAdapter's update function to push the table to SQL Server. It seems that nothing happens. The way I am doing right now is using OleDbDataAdapter to get the DataTable object, then the DataColumn object, and manually extract the table structure and data row by row. SqlConnection is created to insert into SQL Server, and manually covert the System.Type in DataColumn object into SqlDbType in a long switch function. I am not sure I need to do that much in .NET platform for table copy between these two Microsoft database products. Is there an easy way to do this? Thanks for your input!
Reply
Answers (
2
)
How to get table from stored procedure
The more records the more slow adding rows