I would like to get the connection string for both 2003 excel (*.xls) and 2007 excel (*.xlsx). I want to read both files depends upon the selection.
When I was using this code
Dim cn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & a_sFilepath & ";Extended Properties= Excel 8.0;HDR=YES;")
I get an oleDB exception "Could not find installable ISAM" and also I would like to know wheather we can use same connection string for both .XLS and *.XLSX