sql

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 [...]

Oracle Connection String in VBA

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 Oracle Server. We can do connection with Oracle either by giving SID or Service Name. Whichever is available for the connection, we can use connect to the Oracle Database. Before [...]