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
- 9494 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 |
Wat is the command used to add an object(properties) to an object repository?
How do client side image and server side image work?
in my application,validation message has in japanise language.how to validate this message is appears properly or not
How to use actions in qtp ?
What is the descriptive programming?
How you are maintaining shared object repository in your team or your project?help me plz
How u call functions in QTP
how many test scripts we will write in qtp? very urgent. please??? Thanks in advance..
What are the main attributes of test automation?
who is the best faculty in Hyderabad for QTP?
1)what is the quality process in QTP? 2)how to add the .tsr file in qtp through scripting?
A web page title might be xxxx@xyz.com or xxxy@xxx.co or xyz@abc.in.Using what mandatory properties can be the page identified.Give the regular expression for that.
WinRunner 
