Excel Programming >> What is the fastest way to bulk load data into Excel?
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.
Excel Programming >> What is the fastest way to bulk load data into Excel?
Workbooks.OpenText should work.
Ryan
> 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.
>
>