LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jo Jo is offline
external usenet poster
 
Posts: 113
Default Huge file import is truncated

I'm trying to import a text file (raw website stats log) that's in the
neighbourhood of 150MB. Excel 2003 truncates it after a mere 65,536 lines,
which is just a small fraction of the total lines in the file.

Is there any way I can pull the whole file into Excel? I'm running on Win-XP
with 1GB of RAM. Windows and programs are loaded on a 30.4GB partition of a
80GB harddrive. The memory (AFAICT) is system-managed (not manually input).

Any help with this is most appreciated, as I would like to be able to work
with these website stats files on a regular basis, and Excel would be great
and easy to use for this, if I can just get the whole file in there at once!
I don't have Access and am not in a position to purchase it at this point, so
it's going to have to be Excel for now.

Thanks.

Jo
 
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
deleted bitmaps and still have huge excel file size James Excel Discussion (Misc queries) 1 February 10th 06 07:37 PM
Specifying Row / Column in Import File Data Gladiator Excel Discussion (Misc queries) 2 January 6th 06 03:38 PM
import file Mindy Excel Discussion (Misc queries) 20 April 6th 05 04:08 PM
Import Excel Data from another workbook or file tamato43 Excel Discussion (Misc queries) 1 February 28th 05 05:26 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 10:12 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"