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


Please Help Members By Posting Answers For Below Questions

Is QTP Supports SWT applications? If yes, can you write a sample script for opening a new package in eclipse.

3019


Did the scripts need lot of maintenance? If yes, why?

3305


How to check bitmap output value?

634


I need to pull the data from the page which in row, column vice into excel sheet, how can it be done using QTP? eg: Name Dept xyz gdty i need the same data to be exported in excel sheet.

1729


How many ways we can parameterize data in quicktest professional (qtp)?

591






Why qtp the best testing tool?

571


What is the difference between QTP and WinRunner? Why do you choose only QTP for automation among remaing tools like Rational robot and silk test? Write the VBscript for any functionality in your project ? What is the cost of QTP ? If you entered into yahoo mail with your valid user name then you will get FOR EXAMPLE , " welcome to krishna " on the top of inbo page , how can you test it in QTP? What type of testing you can do, when we gave you 5 screens and how can you test that application? What type of framework you are using in your company and explain it?

1799


Should have experience in framework means?

1425


Hi, can explain the draw back of manual testing.plz send me the answer to my mail id deepthip1985@gmail.com

1427


In a flight window we have to enter the name and meal request for every passenger.In that window if we give Total passengers=1 then the Psngr1 name field and psngr1 meal request field will reflects.if we give Total passengers=2 then Psngr1 name field and psngr1 meal request field,Psngr2 name field and psngr2 meal request field and so on. how we can handle this scenerio thru Descriptive programming?

1451


On the website, the protocol has been changed https: to https what you will do? Tell me your approach?

589


what type of framework u r using in ur organization

1657


When to use descriptive programming?

597


How are actions and functions different in QTP?

663


Explain different checkpoints in qtp.

727