connection

Query Database and Spreading the Records in Excel – VBA Code

In continuation to one of my article which shares the connection strings to connect to different data bases. In this article I explained and shared every possible VBA code to make connection with many databases like Oracle, SQL etc. but does the Story ends there?? NO WAY !! That's the starting point. You are going to make connection to Database [...]

How to connect to Access Database – ADO Connection String

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 an Access Database. Access Database connection string is different for Access 2003 (*.mdb) and Access 2007/2010 (*.accdb) because Drivers are different for both the databases. For Access 2003 Database the Provider [...]

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