Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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 text area check point supports for web applications?

976


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

1855


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

2195


How to import a test case present in ".xls" file to TD under a Test set?

1227


What are the advantages of Object Repository?

1097


Explain process of smart Identification in QTP?

1063


How does qtp recognize objects in aut?

1042


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.

2196


How many add-ins comes by default with quicktest professional (qtp)?

1004


How to save your test using quicktest professional (qtp)?

1109


What is accessibility check point?

1094


In qtp is it possible to check broken links of a page?

1049


how do u plan test automation?

1913


What is the short cut keys for the following?

1126


Who uses qtp tool?

990