🚀 go-pugleaf

Para dejar traza: (del correo que me hizo favor de responder Viatcheslav)

Your query should look as:

SELECT * INTO [pagos] IN "" [Excel 8.0;Database=d:\temp\listapagos.xls] FROM 
[pagos]

This one should work. Do not forget to escape " and \ characters in code.


   QuickRep1->Free();

   QuickRep1->~TQuickRep();



ADOCommand1->Free();

ADOCommand1->~TADOCommand();



It is not correct. Use "delete QuickRep1;" and "delete ADOCommand1;" 
instead.




Regards,
Viatcheslav V. Vassiliev
"jayo" <jayo1.geo@yahoo.com> escribi� en el mensaje 
news:422f0b26@newsgroups.borland.com...
> 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
>