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





PostPosted: Tue Mar 29 14:17:05 CST 2005 Top

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.

Excel331  
 
 
Ryan





PostPosted: Tue Mar 29 14:17:05 CST 2005 Top

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