Which provider should I select to connect to Excel version 11 through AdoConnection?

Question

I need to connect to Excel table through TADOConnection, and I don't know what to write into the ConnectionString property. For Excel Version 8 I use Jet, for 12 I use ACE, what about 11?

And how should the ConnectionString look?

Answer 1

Anything prior to v12 can use the Jet connection string. This site is at the top of my bookmark list, because I am always forgetting the proper ConnectionString syntax.

EDIT: I've never run into an ISAM-related error before, but this discussion thread has good info on getting the connection strings exactly correct.