Microsoft ACE OLE DB 12.0 Concepts and usage

A few concepts need to be clear first:

Database Engine: Some of the components that are pre-stored in the data base;

Microsoft Jet (Joint engine technology): Microsoft Jet data Engine, released in 1992, primarily for data connections to Microsoft Accesss, the jet engine, with access only to office97-2003;

Microsoft ACE (Office Access Connectivity engine ): As Access 2007 was released, the Microsoft Jet data Engine ushered in a special change, with the name becoming an access Database engine, Microsoft Ace, which is compatible with previous versions, the ACE engine has access to Office 2007 and Office 97-2003.

　　

Microsoft Jet is destined to be discarded by Microsoft over time, but Microsoft continues to support Microsoft ACE.

Microsoft ACE OLE DB 12.00

Provider=microsoft.ace.oledb. 12.0;D ata source=c:\myFolder\myExcel2007file.xlsx; Extended Properties="Excel 12.0 Xml; Hdr=yes";

　　

Support for Excel 2007 and later versions (suffix. xlsx), "Hdr=yes;" indicates that the first row contains the column name instead of the data, "HDR=NO;" is just the opposite.

　　Treat all data as a text document

Provider=microsoft.ace.oledb. 12.0;D ata source=c:\myFolder\myExcel2007file.xlsx; Extended Properties="Excel 12.0 Xml; Hdr=yes;imex=1";

Treat all the data as a text document, just set "Imex=1" to the default "common type" in Excel to the text type.

Microsoft ACE OLE DB 12.0 Concepts and usage