schwientekd
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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...
ASKER