I need to load an Excel file via a web application into SQL Server. I have been able to load the Excel spreadsheet into my application and store it into a DataSet. How do I load the DataSet into SQL Server?

You can use the Update statement to sync data to the database. You have to map the data set to the data source (using table and column mappings). Here's an article that shows you how to map your data set to your stored procedures, or there are alternative ways:

http://www.dotnetjohn.com/articles/articleid106.aspx

Im not sure about maping, but sorry to say I dont think it(ur link) was a good sample to use! I mention the open() & close() for Connection. So i didnt saw the rest! there is no need Open/Close Connection for SqlAdapter, thats why I disnt trust the rest codes.
Sorry again.

Always:),
Hovik Melkomian.

It was meant to show you how to create the mappings, and to do the update. If you needed to do stored procedures, you could do it this way, but there are other ways.

I am curious; how are you using the update statement without opening and closing the connection? Every time I use the update statement without opening and closing the connection, it errored for me. Also, every example I found opened and closed the connection.

Hi,
How to load the Excel spreadsheet and store it into a ADO.NET DataSet?
Thanks?
Yubo

Could you tell me how to uplaod Excel spreadsheet into a DataSet?
Thanks a lot.
Yubo

Hello,

You can open it through ADO.NET using the Jet provider and setting the extended properties to something like "Extended Properties = Microsoft Excel 9.0 Library" or something like that. You can find info on the web about that.

Brian