Link to home
Start Free TrialLog in
Avatar of schwientekd
schwientekdFlag for United States of America

asked on

Import excel spreadsheet into SQL 2005 using Visual Studio 2008

I need to find a way to import an excel spreadsheet into an SQL 2005 table.  I am developing a VB.NET application in Visual Studio 2008.  Can anyone give me some advice on how to accomplish this?
ASKER CERTIFIED SOLUTION
Avatar of Bob Learned
Bob Learned
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of schwientekd

ASKER

I used the first link to import the spreadsheet data into a DataGridView and instead of a bulk insert I wrote a For Each loop to insert each row into the table.
The bulk insert is optimized over a For Each loop, so you might want to investigate it for the future, and see if it is faster...