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

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.

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

Look he

http://msdn.microsoft.com/library/de...3ac3dc785d.asp

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

Why not link/import it to Access, then size does not matter.

NickHK

wrote in message
oups.com...
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.