Back to Blog
![]() The Who’s Who of MDAC Technologies OLE DB Providers In today’s follow-up, we’re going to construct some connection strings that will allow us to perform queries against the contents of the CSV file using the various Microsoft data providers. In a recent article, we used the Access Export Wizard as a means of generating a Comma-separated-Values (CSV) file. Other MDAC technologies include ActiveX Data Objects (ADO) and Open Database Connectivity (ODBC). It’s one of several Microsoft Data Access Components (commonly abbreviated to MDAC), a framework of Microsoft technologies that presents programmers with a consistent way of developing applications that can interact with almost any data store. ![]() The driver that allows programs and scripts to interface with the JET engine is called the Jet OLE DB Provider (where OLE refers to Microsoft’s Object Linking and Embedding technology). ![]() Although it has been incorporated into several Microsoft products since then, it’s still synonymous with the Microsoft Access product line. ![]() The Microsoft Jet (Joint Engine Technology) Database Engine was created in 1992 for Microsoft Access.
0 Comments
Read More
Leave a Reply. |