Read Excel Sheet Data into DataTable or Dataset
Without using Excel Object we can insert , edit , delete , select etc. in cell content of an Excel file using OLEDB in VB.NET . Here we are using OleDbConnection , OleDbDataAdapter , DataSet for doing these operations in an Excel file. You have to import System.Data in the project for doing these operations . For read the content from Excel file using ado.net , We can use the SELECT command like in SQL Operations.
Import Excel to DataTable
sample Select sql
Here is the sample Excel file.
Open the connection using OLEDB Provider
Specify which data you want to read
Here is the screen short after reading from Excel file.
Fastest way to read an Excel Sheet into a DataTable
When you execute this program you will get the contents in the excel file to the DataGrid.