>I did adapt my class to support this:
>
>
> ' Based on the type
> Select Case loFileType.nNoFileType
>
> ' XLS
> Case 3
>
> ' Initialization
> lcConnection = "provider=Microsoft.Jet.OLEDB.4.0; data source='" + cSource + "'; Extended Properties=Excel 8.0;"
>
> ' XLSX
> Case 18
>
> ' Initialization
> 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?
I think this came up in another thread recently. The database engine is still used 'under the hood' for a lot a MS stuff - so, yes, you need it :-{