SQL Connection using Excel Macros

Using Excel Macros (VBA) you can connect to any Databases like SQL, Oracle or Access DB. In this Article you will learn, how you can do a connection with a SQL Server. SQL Connection can be of different types, like using windows authentication or by SQL Server Authentication. Before running the below code, you need to Add reference for ADODB [...]