Reading From an Excel File

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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: