devxlogo

Reading From an Excel File

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.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist