I need to connect to Excel table through TADOConnection, and I don't know what to write into ConnectionsString property. For Excel Version 8 I use Jet, for 12 I use ACE, what about 11? And how should connectionstring look?
views:
18answers:
1
A:
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.
Stewbob
2010-02-23 15:21:21
When I use Jet with this excel file I get error "Could not find installable ISAM". Do you know how to solve it?
Tofig Hasanov
2010-02-23 15:42:07