Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import troubles
Hi,
For Excel (2000) trying to import an .txt/notepad file. It's large (25mb) Only half the file (65,000 names/address, etc) is downloading, than get error message. And excel sheet stops at 65,000 and rest is all gray. So not sure if imported and can't see. What is the limit to import into Excel? I have tried to cut the .txt file in half and have 2 .txt files and 2 excel files to minimize size but difficult to copy/paste or copy/edit in Notepad. These functions don't work as well as they do in Word or Excel. Suggestions? Thanks. -- Paul |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import troubles
Just read some posts. I don't want to do the macro as see it recommended a
lot for over 65,000 rows. How can I cut the .txt file in 2? I have no issue with having 2 separate Excel files. The copy/paste copy/delete not working in Notepad. -- Paul "QuestionMan" wrote: Hi, For Excel (2000) trying to import an .txt/notepad file. It's large (25mb) Only half the file (65,000 names/address, etc) is downloading, than get error message. And excel sheet stops at 65,000 and rest is all gray. So not sure if imported and can't see. What is the limit to import into Excel? I have tried to cut the .txt file in half and have 2 .txt files and 2 excel files to minimize size but difficult to copy/paste or copy/edit in Notepad. These functions don't work as well as they do in Word or Excel. Suggestions? Thanks. -- Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Import Wizard (use for large files) | Excel Discussion (Misc queries) | |||
import filtered data | Excel Discussion (Misc queries) | |||
I NEED TO IMPORT MORE THAN THE 65,536 LINES EXCEL ALLOWS | Excel Worksheet Functions | |||
import data with macro | Excel Discussion (Misc queries) | |||
import data using macro | Excel Discussion (Misc queries) |