LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reformating large amount of data Jason Excel Discussion (Misc queries) 2 April 10th 08 10:41 PM
Best way to easily export large amount of data from Excel hmsawyer Excel Discussion (Misc queries) 1 April 5th 08 08:14 PM
Changing large amount of Data glnbnz Excel Discussion (Misc queries) 5 January 12th 07 07:44 PM
how do i save a large amount of data in a worksheet excel 4 Rana Excel Worksheet Functions 1 June 13th 06 10:54 AM
Large amount of data for plotting dharshanie Charts and Charting in Excel 7 May 24th 06 05:08 PM


All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"