Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
deleted bitmaps and still have huge excel file size | Excel Discussion (Misc queries) | |||
Specifying Row / Column in Import File | Excel Discussion (Misc queries) | |||
import file | Excel Discussion (Misc queries) | |||
Import Excel Data from another workbook or file | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |