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.

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.
>
>