Interested to Buy Any Domain ? << Click Here >> for more details...
what is the script(qtp) to export and import the datas from
MSaccess to Excel sheet.if anybody know plz tell me.
- 3 Answers
- 9216 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / e.g.g
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 ? | 3 Yes | 1 No |
Answer / king
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 |
Answer / devb
If you want to fetch data from access database and write into excel, the easiest way is to write VBA code. In macro directly connect to access database, fetch data into recordset and using range.copyfromrecordset save the data into excel sheet. No need to involve QTP.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain how you can delete excel file in qtp?
Which MS Excel formulas are possible to use in the DataTable? I am searching a formula for searching a field in the datatable
How can i select multiple items from a WebList bOX USING QTP
What is the use of ordinal identifier in qtp?
How to change the run-time value of a property for an object in QTP?
What is quicktest professional (qtp window?
how can i use text check point in descriptive programming. or else is there any way to compare the text in the application and the text in data table.
Do we get any issues if we run the testscript on different browsers? what are the options we need to st in QTP?
suppose 3 excel sheets are there * we are trying to check for login credentials for a page. userid from excel1 , password is from excel2 whether the page is opened or not that checkpoint is result is should be stored in excel 3.... this qus i have faced in IBM technical round... please tell script for above query
Read excel using qtp descriptive programing
What are the different recording modes and how do they work?
where the log files stored when using QTP? plz send answer to me ........
WinRunner 
