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
- 9486 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is TOM in QTP?
Explain building blocks of the bpt framework ?
How to delete an object from the object repository?
when u script reveiwing in which area u more concentrates?
What are the types of properties that quick test learns while recording?
What are the technics follow in writing VB script?
How to record application running on the Virtual machine?
in data driven testing for performing operations which method is easy from manual test data,keyword view,or from database.and why?
Pls can anybody send me the Recent Technical and Interview Questions Which were asked in IBM(QTP)Automation PLZZZZZZZZZ
How do I generate Test Results window using descriptive method ( run time ) after my test execution process? Please have a look of my below code. ========================================================= Dim qtApp Dim qtTest Dim qtResultsOpt Set qtApp = CreateObject("QuickTest.Application") qtApp.Launch qtApp.Visible = True qtApp.Options.Run.CaptureForTestResults = "Always" qtApp.Options.Run.RunMode = "Fast" qtApp.Options.Run.ViewResults = True qtApp.Open "C:\Automation\Example", True Set qtTest = qtApp.Test qtTest.Settings.Run.OnError = "NextStep" Set qtResultsOpt = CreateObject ("QuickTest.RunResultsOptions") qtResultsOpt.ResultsLocation = "C:\Automation\Example\Res1" qtTest.Run qtResultsOpt MsgBox qtTest.LastRunResults.Status qtTest.Close Set qtResultsOpt = Nothing Set qtTest = Nothing Set qtApp = Nothing ========================================================== This code is working fine, but Test Result window is not displaying after execution. Anybody can please help me regading the same. Thanks Akshaya Madali Capgemini India Pvt Ltd 9823213538
why text area checkpoints cannot used for web applications
When QTP object wait time is 10 seconds, and in test script wait time is 5 seconds and in function library wait time is 2 seconds how much time does the wait occur? or which is given priority.
is there any addin for remedy user application
How many types of recording modes in qtp?
How many ways we can parameterize data in quicktest professional?
