large amount of data moving to excel

[Gshack]

I am using a program to collect data at 150 points a second (time - excel
rows) and testing several different criteria (temperature, voltage, position,
ect...columns in excel). After 7 ½ minutes of testing the file becomes to
large for excel to open (65536 rows) my test will last for hours. I have
found that Microsoft Word, Notepad or Wordpad will open the file. But moving
the data over to excel takes a very long time to cut and past. And after the
file is moved over into Excel I have to again cut and paste into columns of
32000 rows because I have to chart the results.

Is there away to go from one of these other programs and move the data over
into a useable excel file quickly?

 

[Pete_UK]

Chip Pearson has a macro here:

http://www.cpearson.com/excel/ImportBigFiles.aspx

which will enable you to import a large file and split it
automatically into different sheets when rows exceed a number that you
specify - seems exactly what you need.

Hope this helps.

Pete