Interestingly, this connection string WILL successfully open an XLS file, which is just confounding to me, as from what I can tell an XLS file should use "Excel 8.0" to be successful.

I had been passing username/password strings directly into the ADO.NET connection string, however this means that if a user has a quote character in his password, it borks the ConnectionString and ...