Andy Davies wrote: >>The easiest and fastews way, imo, is to read the data with ado, next use >>the copyfromrecordset method to copy to excel. > > > Jaime, > what advantages does ado have over e.g. 'copy to xxx type xl5' ? >
Andy, Advantages, imo: More control, with copy to... , you have to createa a file for any worksheet and later marge each file to a workbook, wich tends to more erros and larger programming. With ADO, you only have to get a referencie to the range where you want to copy the results, that can be any cell in any worksheet. Speed, no need to create phisical files, everything is done in memory. No need to deal with odd codepage conversions. ADO is the method Excel underestands better. Remember use the right tool for the job. :) HTH Saludos, Jaime Vasquez Guatemala C.A. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
