Comments by virendra shirvadkar (Top 1 by date)

Hi,

Please look at this article.

How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET

In this example, it tell you how to use the Jet OLE DB Provider with Microsoft Excel Workbooks and how to use Excel Workbooks as ADO.NET Data Sources(just look the Excel Workbook as a database).



The important components in this example are:

OLEDbCommand

Represents an SQL statement or stored procedure to execute against a data source.



OleDbDataAdapter

Represents a set of data commands and a database connection that are used to fill the DataSet and update the data source.

Regards,
Virendra Shirvadkar