How to create an Excel file from a Cpp builder 5 pgm using ADO Express

Article View: borland.public.cppbuilder.database.ado

Article #925

Back to borland.public.cppbuilder.database.ado Previous Next

#925

From: jayo
Date: Wed, 09 Mar 2005 14:41

33 lines
1882 bytes

I'm using BCB 5, with ADO Express I create an Access database, with a table. 
I want that table in an Excel file. I am doing:
.
.
.
ADOConnection1->ConnectionString = bt; // Access
ADOConnection1->Open();
ADOTable1->Connection= ADOConnection1;
ADOTable1->TableName= L"PAGOS";
ADOTable1->Open();
.
.
   ADOTable1->Append();
   ADOTable1->FieldValues[AnsiString("CCLIENTE")]=AnsiString(clien);
   ADOTable1->FieldValues[AnsiString("NCLIENTE")]=AnsiString(nombre);
.
.
   ADOTable1->Post();
.
.
WideString yt="SELECT * INTO Excel 10.0;DATABASE= LISTAPAGOS.PAGOS FROM
PAGOS";
   ADOConnection1->Execute(yt, ?, ?); // What parameters to use ?   ERROR
.
.
   QuickRep1->Preview();
   QuickRep1->Free();
   QuickRep1->~TQuickRep();
ADOTable1->Close();
ADOConnection1->Close();

Thank you very much in advance.
Jesus

Technical Details

Message-ID: <422f0b26@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!news.wiretrip.org!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!feeder.enertel.nl!nntpfeed-01.ops.asmr-01.energis-idc.net!news-out.nntp.be!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,2e49c0607a2d6636,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "jayo" <jayo1.geo@yahoo.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: How to create an Excel file from a Cpp builder 5 pgm using ADO Express
Date: Wed, 9 Mar 2005 08:41:46 -0600
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
NNTP-Posting-Host: 148.240.100.214
Message-ID: <422f0b26@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1110379302 148.240.100.214 (9 Mar 2005 06:41:42 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!news.wiretrip.org!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!feeder.enertel.nl!nntpfeed-01.ops.asmr-01.energis-idc.net!news-out.nntp.be!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail