Excel connection Strings for .Net Application

It is using OleDb as a Object for the connection to the Excel File.
OleDbCommand, OleDbConnection etc
2007

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=path\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1";

2003

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

Reading from Sheet

SELECT * FROM [SheetName$]

Here dollar sign ($) is compulsory