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