View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gshack Gshack is offline
external usenet poster
 
Posts: 1
Default 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