large amount of data moving to excel
 

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?

--
GShack

large amount of data moving to excel
 

Chip Pearson has a macro he

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

On Jul 25, 1:31*pm, Gshack wrote:
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?

--
GShack