import xls to sqlserver table

[sivaram praveen]

hi all, in my application using vb.net 2003 im trying to import excel sheet to a table existing in sql server 2003, i have searched in net for this but could only find vb.net 2005 results where "sqlbulkcopy" is used but that doesnt work in vb.net 2003 pls help me

[pmarfleet]

This article[^] shows how to query an Excel speadsheet using the Jet OLEDB Provider. Once you have your data in a DataTable, you can iterate through it and run INSERT queries against your SQL Server database. The code is in C# but it should be trivial to convert it to VB.NET. If your spreadsheet is particularly large, you may want to consider using DTS/SSIS to perform the import and trigger the operation from your .NET code.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush