Reading Excel File 2007 format or any other formats using ODBC

To read an Excel File irrespective of the formats, one can use the following connection string:

"Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=<Complete Path with File Name>;"

For example:

[Collection: Excel Contents]

ODBC: "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=C:\Tally.ERP9\Ledgers.xlsx;"

SQL   : Select * from [Sheet1$]