what is the script(qtp) to export and import the datas from
MSaccess to Excel sheet.if anybody know plz tell me.
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
Where we can use the analog mode and where we can use the low – level mode?
what is the diff b/w assistive and mandatary rules of object repository in QTP???
What is checkpoints for qtp?
What is the difference between per-action and shared?
How does qtp identify gui object?
How will internal and external links be validated and updated? how often?
Which features or drawbacks of QTP lead to the upgrade for a newer version?
What are the advantages of parameterization ?
The structure of keyword driven frame work is like a folder structure the different sub folder are 1-functional libray folder 2-object repository folder 3- database folder 4-appliction1.xls 5-initalzation vbs file 6-sequence file 7-driver script 8-test case list file My question is whether these are in a local server machine or in our pc.((whether It like Vss). can u give example of driver script(code)
Hi, How Accessibility checkpoint in QTP can be implemented in the test script?
whenever U using QTP,Test Director, Why we using separate Bug tracking tool?
What is the latest version of qtp?
Does QTP record on Objects created on XWindows Environment?
Hi Friends, How many types of Data Bases available in market... What is the diff. while using Syabase and Oracle in a Project... ? and what is the main diff. of Syabase and Oracle databases... ? Thanx in advance..
What is the use of ordinal identifier in qtp?