Question:
Is there a way to store data in an Excel file from an ADO recordset by doing some sort of block read/write instead of reading/writing every data field in a loop ?
Answer:
Here’s a quick trick. Write the data out to a tab and carriage return delimited text file then give it an .xls extension. When the user open the file Excel will automatically import it to an Excel spreadsheet. To quickly generate a tab delimited string, use ADO’s GetString method.