摘要:
QTP访问SQL数据库Dim conn,resSet conn = createobject("adodb.connection")connstr = "Provider=SQLOLEDB.1;Password=Password01!;Persist Security Info=True;User ID=sa;Initial Catalog=PCRM2;Data Source=ws-gisgtssts-03\paypaltestserver"conn.Open connstrSet res = createobject("adodb.recor 阅读全文
摘要:
QTP从数据库中导出数据到excel中Set objExcel = createobject("Excel.Application")xlsUrl = "C:\aa.xls"objExcel.Workbooks.Open(xlsUrl)Set sheetNew = objExcel.Sheets.Item(1) '把数据库中的内容保存到excel的sheet1表中Set conn = CreateObject("adodb.connection")set res = createobject("adodb.recor 阅读全文