Query to MSExcel

[LastCyborg]

I'm programming a DataBase which has some queries, but I need an option to export a query to MSExcel.

How can I do that?

 

[Cagliostro]

Excel is not a query based database. I'd say is not a adtabase at all, however you can use it to store data. You should use OLE to export/import from excel

Ion Filipski

ICQ: 95034075
AIM: IonFilipski
filipski@excite.com

 

[LastCyborg]

I need to pass the query just like you see it in a grid

 

[Cagliostro]

I do not knw why do you need BorlandC++ there.
Open excel, and do a menu command:
data->getExternalData->RunSavedQuery or NewDatabaseQuery ....

Ion Filipski

ICQ: 95034075
AIM: IonFilipski
filipski@excite.com