Connect SQL Server from excel and retrieve data

Описание: ADO Stands for ActiveX Data Objects, is Microsoft's Client-Server technology to access the data between Client and Server. ADO can't access the data source directly, it will take help of OLE DB Provider to communicate with the data source.

OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB), an API designed by Microsoft, allows accessing data from a variety of sources in a uniform manner.

An ODBC driver uses the Open Database Connectivity (ODBC) interface by Microsoft that allows applications to access data in database management systems (DBMS) using SQL as a standard for accessing the data. ODBC permits maximum interoperability, which means a single application can access different DBMS

Record set Object. The ADO Record set object is used to hold a set of records from a database table. A Record set object consist of records and columns (fields).

#PracticalIT #VBAADO #ConnecttoSQLServerUsingVBA