CONNECTION STRING

Different ways of Reading RecordSet Object in Excel Macro

Dear Friends, In my previous article, I emphasized mainly on how to execute different kind of queries in database using Excel VBA. I covered one example How to display or spread a RecordSet in excel Sheet. But in this article I am going to focus on different ways of reading RecordSet Object. How to get Column Names from your recordSet [...]

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