Reading and working with a long CSV (more than 100K lines).

  • Thread starter Thread starter mikesalemi
  • Start date Start date
M

mikesalemi

I have a very long CSV file (more lines than Excel can handle). Is it
possible to read and work with the data in the CSV file using Excel
VBA?

For example let's say my CSV file looks like this:

1,2,3
4,5,6
7,8,9

I'd like to be able to loop through the csv to the end of file,
reading each value into a variable that holds the running count of each
column (3 variables total).

Thanks so much.
 

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

CSV files and having numbers and strings in there... 9
Reading data from CSV file 2
CSV decoding line-by-line 15
Delete first line From CSV file from excel 1
How can I overwrite the last line data in text or csv file from VB 1
How write into text file at first and last line with excel vba? 3
Automate Excel export to a CSV file 1
Looping Open and Save as CSV 9

Back
Top