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

G

Gail Hurn

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import csv data in excel using vb 1
CSV->Excel Data Problem 1
Using Excel to search Word documents? 2
What csv standard used by excel? 1
The fastest way to count values in a range 3
Multiple Forms for Data Entry; re-loading data 1
Loading Data into MultiPage UserForm 1
excel VBA programmer, what is the value of adding access for data 4

Top