Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!feeder.news-service.com!newsfeed.kamp.net!newsfeed.kamp.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: =?iso-8859-1?Q?E=AE!k_\\/!$$E=AE?= Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Vo2Ado & Report Pro Date: Sun, 12 Jun 2011 20:04:10 +0200 Lines: 38 Message-ID: <95kdcoFddlU1@mid.individual.net> References: <651ec04c-5b62-4668-b010-d4c6cb2bea34@n11g2000yqf.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Trace: individual.net FxRWZUz0gEVr54l4VBAadgaNJVbCF8ky89BTVQs6BqJraz+4q7 Cancel-Lock: sha1:Of9Y74HeaqlhXUUTopbpjU3NWh8= In-Reply-To: <651ec04c-5b62-4668-b010-d4c6cb2bea34@n11g2000yqf.googlegroups.com> X-Priority: 3 X-MSMail-Priority: Normal Importance: Normal X-Newsreader: Microsoft Windows Live Mail 15.4.3508.1109 X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3508.1109 Xref: x330-a1.tempe.blueboxinc.net comp.lang.clipper.visual-objects:1362 Hi Rob, 1) there are several ways to do this. a) use automation, open a Excel worksheet and pass and array with your data to a Excel range. b) use the AdoRecordSet:Getstring() method to create a CSV file. 2) have you studied the VO2ADO report pro samples? regards, Erik "Rob van Erk" schreef in bericht news:651ec04c-5b62-4668-b010-d4c6cb2bea34@n11g2000yqf.googlegroups.com... Hello all, Two questions: 1) Are there any examples available on how to export SQL Data (VO2.8 using Vo2Ado) to another format like Excel? I have some examples showing SQL data in bBrowser cells but no idea how I can export data to Excel format. 2) I am using Report Pro 3.9 but do not understand how I can open a SQL database in Report Pro. In this forum I read something about using RDD but not sure what is exactly meant. By default I think I need to use some ODBC connection method in Report Pro but preferably I use Ado directly from within ReportPro (if possible). It has been a long time since I have been working with VO so any help to support me to start up using VO again would be helpful. Thks,