Loading

Reading data from Excel Sheet using oledb connection

srinivas

hi to all can any one explain how to use oledb to connect excel sheet and how to read data from excel sheet and after reading i have to store that data into a class like
class bookinfo
{
int bookid;
int bookname;
}
plz help me
thank you

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

srinivas16y ago
sorry i already read that links but i cant understand those examples do you know any other simple examples
and i am getting an error like could not found ISAM installed
plz help me

thanks

0
Lalit M16y ago
here articles of reading data from excel 2003/07 using oledb connection show here

Connection String
To access an Excel workbook by using the Jet OLE DB Provider, use a connection string that has the following syntax:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties="Excel 8.0;HDR=YES;"

read more here & Here
0

Reading data from Excel Sheet using oledb connection

Connection String