It is the simple program. it explains how to connect MS-Excel Database.
Creating Table in Excel is very simple and easy. also fetch from Excel table is also very easy.
Using the code
For Connect the Excel, we have to use the normal OLEDB connection as follows :
string Con_Str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DB_Path + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\";";
Here DB_Path is the location of the .XLS file.
"HDR=Yes;" indicates that the first row contains columnnames, not data.
"HDR=No;" indicates the opposite.
"IMEX=1;" tells the driver to always read "intermixed" (numbers, dates,
strings etc) data columns as text. Note that this option might affect
excel sheet write access negative.