🚀 go-pugleaf

This is what works:



ADOCommand1->CommandText = "SELECT * INTO [PAGOS1] IN 
\"D:\\Temp\\LISTAPAGOS.XLS\" [Excel 8.0;]  FROM [PAGOS]";



Jesus

"jayo" <jayo1.geo@yahoo.com> escribi� en el mensaje 
news:42330302@newsgroups.borland.com...
> 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
>>
>
>