ExcelBanter - What is the fastest way to bulk load data into Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - What is the fastest way to bulk load data into Excel? (https://www.excelbanter.com/excel-programming/326387-re-what-fastest-way-bulk-load-data-into-excel.html)

[email protected]

What is the fastest way to bulk load data into Excel?

Workbooks.OpenText should work.

Ryan

"Gail Hurn" wrote:

I need to load a large amount of data into Excel. Right now, I'm creating a
CSV file and loading the CSV using Worksheet.QueryTables.Add(fileName, cell,
missing). It seems pretty fast, but I was wondering if this is the best way
to do this or is there another way that would be even faster.

All times are GMT +1. The time now is 07:04 AM.