Excel Macro

How to Connect Database and Import Data From Database in Excel through VBScript or QTP

Import Data From Database In this post I tried a simple mechanism by a highly customizable code for connecting Database from Excel or QTP by using a VBA or QTP code. Import Data From Database The code will look like- Dim cnnt Set cnnt = CreateObject(“ADODB.Connection”) cnnt.Provider = “SQLOLEDB” //provider can be any…..like sql,mysql cnnt.ConnectionString= …

How to Connect Database and Import Data From Database in Excel through VBScript or QTP Read More »