All geek questions in one place

Which provider should choose to connect to Excel version 11 through AdoConnection?

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

And what should ConnectionString look like?

+3
source share
1 answer

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

EDIT: , ISAM, , .

+2

Source: https://habr.com/ru/post/1734017/

More articles:


All Articles