Exporting ADOQuery Results to Excel

I need to export the results of an ADOquery to Excel.

Currently, I am looping through the recordset writing the field values to a
stringlist, which is saved as a text file. Using the excel server
components I open this file in excel and finally save it in Excel format.

I was wondering whether there was an easier way of doing this?

Nirmal


.

Relevant Pages

  • Re: Is it possible to export each row of data to a seperate work book
    ... It just keeps looping. ... Stacey ... "Dick Kusleika" wrote in message ... > Excel Blog - Daily Dose of Excel ...
    (microsoft.public.excel.programming)
  • Re: Need code to copy from "code modules"
    ... See Chip Pearson's page Coding for the VBE ... HTH, ... My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm ... > I am looking for (looping) code to copy the contents of the ...
    (microsoft.public.excel.programming)
  • Re: Access Freezes
    ... Your Resource For Help With Access, Excel And Word Applications ... Need a month calendar or 7 day calendar? ... > The subroutine takes some time, ... > I have a progressbar that works while the subroutine is looping. ...
    (comp.databases.ms-access)
  • Re: Export DataSet to Excel
    ... > should be faster to copy all of your data rows in one go to excel. ... > it is finished as it seems to take up a lot of processing power. ... >> I'm looping through my datarows, adding them one by one to the file. ... seems to open when i open excel whilst ...
    (microsoft.public.excel.programming)
  • Re: Export DataSet to Excel
    ... should be faster to copy all of your data rows in one go to excel. ... On My PC I am able to run a number of instances of Excel at the same time - ... > I'm looping through my datarows, adding them one by one to the file. ... seems to open when i open excel whilst ...
    (microsoft.public.excel.programming)