I did adapt my class to support this:
Select Case loFileType.nNoFileType
Case 3
lcConnection = "provider=Microsoft.Jet.OLEDB.4.0; data source='" + cSource + "'; Extended Properties=Excel 8.0;"
Case 18
lcConnection = "provider=Microsoft.ACE.OLEDB.12.0; data source='" + cSource + "'; Extended Properties=Excel 8.0;"
End Select
However, at first, it says this:
"Microsoft.ACE.OLEDB.12.0' provider is not registered on the..."
So, this was required to make it work:
"2007 Office System Driver: Data Connectivity Components"
Once prompted to download, I ended with this file: AccessDatabaseEngine.exe
This works. But, I have some doubt as to know what was installed exactly.
So, when looking at the program files, I see: "Microsoft Office Access database engine 2007 (English)"
Talk about going around something you do not want. Is there really such a driver or we have to install this Access software?