ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Testing  >>  Automation Testing  >>  QTP
 
 


 

 
 WinRunner interview questions  WinRunner Interview Questions
 Load Runner interview questions  Load Runner Interview Questions
 QTP interview questions  QTP Interview Questions
 Test Director interview questions  Test Director Interview Questions
 Rational TestSuite interview questions  Rational TestSuite Interview Questions
 Silk Test interview questions  Silk Test Interview Questions
 Automation Testing AllOther interview questions  Automation Testing AllOther Interview Questions
Question
what is the script(qtp) to export and import the datas from 
MSaccess to Excel sheet.if anybody know plz tell me.
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the script(qtp) to export and import the datas from MSaccess to Excel sheet.if anybody know plz tell me.
Answer
# 1
hi, I'm  you may export the access's datas into the QTP 
datatable first,import it into the excel second.
haha,this maybe a foolish method  -_-||
 
Is This Answer Correct ?    2 Yes 1 No
E.G.G
 
  Re: what is the script(qtp) to export and import the datas from MSaccess to Excel sheet.if anybody know plz tell me.
Answer
# 2
Set a=createobject("adodb.connection")
Set b=createobject("adodb.recordset")
a.provider="microsoft.jet.oledb.4.0"
a.open "E:\raju\login.mdb"
b.open "select *  from login",a
i=1
Do while not b.eof
	If not dialog("Login").Exist(2) Then
	invokeapplication "C:\Program Files\Mercury 
Interactive\QuickTest 
Professional\samples\flight\app\flight4a.exe"
	End If
	dialog("Login").WinEdit("Agent Name:").Set b("User 
name")
	wait(1)
	dialog("Login").WinEdit("Password:").Set b
("password")
	dialog("Login").WinButton("OK").Click	
	datatable.SetCurrentRow(i)
	datatable(1,1)=b("User Name")
	datatable(2,1)=b("password")
    wait(1)
	If dialog("Login").Dialog("Flight 
Reservations").Exist(1) Then
	dialog("Login").Dialog("Flight 
Reservations").WinButton("OK").Click
	datatable(3,1)="Fail"
	dialog("Login").WinButton("Cancel").Click
	else
	datatable(3,1)="Pass"
	Window("Flight Reservation").Close
	End If
	i=i+1
	b.movenext
Loop
datatable.ExportSheet "E:\raju\db.xls",1


i think this is working properly
 
Is This Answer Correct ?    2 Yes 1 No
King
 
 
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
What is All object and Local object in Object Repositary? Explain me please.  3
What u say as experience(Interview) "TELL ME ABOUT UR SELf"? As a Fresher(interview) What u Say? ShopRite2
what is descriptive.create()in qtp? IBM2
Hi all , I am new at QTP I want a sample script to check validation messages(For java script or VB script) for login page with for web based application.. Any one can Help. I have to complete it in two days I need urgent help.. Ex. if I want to check mail.yahoo.com 1 > If user doed not exist it display "Username does not exist" 2> if invalid Uname and password then it display" Invalid Uname or pass" 3> Loing Sucssessfully. I want to check this types of application by using data table to give values of username and password.. Thanks  2
How will u declare a variable to access multiple actions? a)Dim b)Global c)Public d)Private  1
What r the different type of reports generated in Quality Center? TCS1
how to change the properties of object during run time . plz give the code using flight reservation  1
How to handle "Java Runtime error" popup window in the web application ? Sometimes the application throws the error repeatedly... Is there any browser setting available to disable the error ? TCS2
We have an application which generates links( more than thousand) based on the time stamp dynmically.Each link will download an xls file. we are supposed to click a particular link (which link to click will be obtained thru some buisiness logic).Now the issue is QTP is not recogniging the link(say Var1) though its properties showed mandatory fields text=xyz and html tag=A.I used following code to do this. Browser("ABC").Page("123").Link("text:=" &Var1,"html tag:=A").click, can any one suggest why this is not recognised by QTP though syntax is correct?(Is there any sync issue to be considered?Because on clicking the link it will take 5 mins to open that file)  2
How many ways we can parameterize data in QTP? Liquid-Crystal5
I want to create Excel object on another machine which is in network i written the code "Set se=createobject ("Excel.Application","\\ankur")"here \\ankur is the name of that machine but i m getting the error of permission denied create object can anybody help me  1
How we can add actions in the test using QTP?  4
If you have given 1000 manual test scripts, what test you will do? and how?  2
any challange that faced in your project? (please give me some examples in your project?  1
Thanks Rag... One more question, How we test the dynamic images which frequently changed?Using the bitmap checkpoint r any other options available.... Can u give the steps pls... Thanks  1
1. I have asked the same question for the third time, but i am getting wrong answers. Pls give me the script to count the number of edit boxes or checkboxes in an windows application screen. In windows application childobject is not working, anyone very urgent  8
HI, Anybody can explain Automation Test Framework...and wht do we do before start of Automation..... Siemens2
Friends please let me know how id following possible in QTP: Can I apply conditional loop on a bitmap/image or any other checkpoint. Like if checkpoint passes then if or Else  2
Can any body tell me how can I choose the share object repository and per action object repository mode. Please give me with steps.  3
How to send QTP scripts to our colleagues? Virtusa1
 
For more QTP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com