The difference between microsoft.jet.oledb.4.0 and microsoft.ace.oledb.12.0

When you connect an Excel object via ADO (at which point Excel is considered a data source), you need to configure the connection string for the Excel data source, which includes the provider information (in fact, you need to specify the connection strings when connecting to the database). Here is a line of connection string source code:

strconnstring = "Provider=microsoft.ace.oledb.12.0;data source=" & Strexcelfilepath & "; Extended Properties=excel 12.0 "

Here the provider use microsoft.ace.oledb.12.0, in fact, in addition to microsoft.ace.oledb.12.0, there are microsoft.jet.oledb.4.0, they have what connection and difference between the two:

Common denominator: All are interface engines that connect to Excel objects

Different points:

For different versions of Excel, there are two interfaces to choose from: Microsoft.Jet.OLEDB.4.0 (hereinafter referred to as Jet engine) and microsoft.ace.oledb.12.0 (hereinafter referred to as the ACE engine).

The Jet engine can access office 97-2003, but you cannot access office 2007.

The ACE engine is a database connectivity component that is published with Office 20,071, and you can access Office 2007 or office 97-2003.

Additionally:microsoft.ace.oledb.12.0 can access the Excel file that is being opened , and microsoft.jet.oledb.4.0 is not possible.

So, when using different versions of Office, be careful about using the right engine.

The difference between microsoft.jet.oledb.4.0 and microsoft.ace.oledb.12.0 (RPM)