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?
 
jacksonm1234Author 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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.