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
Is text area check point supports for web applications?
i need to add 1000 users in a domain i written the script for that and it is running successfuly but the problem is that my system is not the user of that domain in which i have to add users so for adding users in that domain i have to install qtp on that another system, can anybody suggest me the way to add those users from my system ultimately i want to know how to access remote computer through script
Hello, Is there any way to send the test results in html format (or any other) by email using outlook after the test run ends? thank you in advance
How to import a test case present in ".xls" file to TD under a Test set?
What are the advantages of Object Repository?
Explain process of smart Identification in QTP?
How does qtp recognize objects in aut?
HI Everybody, I am using QTP 9.2, I have a problem and hope everybody help me solve it. Now I need to use mouse wheel event to zoom in or zoom out in web client, but QTP can't catch this event. I look forward helping of everybody. Thank you very much.
How many add-ins comes by default with quicktest professional (qtp)?
How to save your test using quicktest professional (qtp)?
What is accessibility check point?
In qtp is it possible to check broken links of a page?
how do u plan test automation?
What is the short cut keys for the following?
Who uses qtp tool?