| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reading and working with a long CSV (more than 100K lines).
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data which is over 65536 lines long | Excel Discussion (Misc queries) | |||
| 100M = 100,000,000; 100k = 100,000 | Excel Programming | |||
| Parse a long string into lines? | Excel Programming | |||
| Reading long strings (with jdbc) from Excel | Excel Programming | |||
| how do you skip lines when reading a text file | Excel Programming | |||
Linear Mode
