VB .Net DataAdapter Problem

Hi Everyone,

My question is faily straightforward (i think).  

I have a dataset full of 20,000 rows of data (obtained from an excel spreadheet) that I would like to insert into a database table.  I'm not sure how to do it.  I think I may need to use a dataAdapter and the associated InsertCommand, but I'm somewhat lost. Can anyone provide example code to help me out? Thanks!
LVL 2
jacksonm1234Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jacksonm1234Connect With a Mentor Author Commented:
jtoutou:
The problem was getting the data from a dataset to a database, not getting excel data into a dataset.
0
 
jacksonm1234Author Commented:
Thanks for your reply.
First link -- I'm not interested in VB6.
Second link -- I dont think there is any mention of visual basic .net in any of those replies.
 
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
John (Yiannis) ToutountzoglouInstructor Multiengine PilotCommented:
What kind of database you want to use?
0
 
jacksonm1234Author Commented:
Eventually, I'll put it into a Teradata table (using an ODBC driver).
Conceptually, though, I dont know how I would do it using ANY database.  I mean, it wouldn't make sense to set up a loop that inserts each row one by one, would it?
That's why I thought a dataadapter may be the answer, but I'm not sure how I would put it together.
0
 
John (Yiannis) ToutountzoglouInstructor Multiengine PilotCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.