Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split a text file with more than 65536 lines over many worksheets
Hi everyone,
I would like to process a text file with more than 65536 lines. Is there any possiblity to do that with Excel ? Either to do it in many iterations (like import lines 1 to 65536, then 65537 to 131072, and so on) or to import it once and split lines 1 to 65536 on sheet 1, lines 65537 to 131072 on sheet 2 etc... Thanks for any feedback & have a great weekend! Joel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split a text file with more than 65536 lines over many worksheets
I would use a text editor to split the text file into smaller pieces (maybe
notepad???). Then you can import each piece into different worksheets/workbooks. On 07/16/2010 07:23, jo77 wrote: Hi everyone, I would like to process a text file with more than 65536 lines. Is there any possiblity to do that with Excel ? Either to do it in many iterations (like import lines 1 to 65536, then 65537 to 131072, and so on) or to import it once and split lines 1 to 65536 on sheet 1, lines 65537 to 131072 on sheet 2 etc... Thanks for any feedback& have a great weekend! Joel -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split a text file with more than 65536 lines over many worksheets
Adding to Dave, you might consider an upgrade to Excel 2007 or 2010 where
you have 1million rows to work with. Best wishes Harald "jo77" wrote in message ... Hi everyone, I would like to process a text file with more than 65536 lines. Is there any possiblity to do that with Excel ? Either to do it in many iterations (like import lines 1 to 65536, then 65537 to 131072, and so on) or to import it once and split lines 1 to 65536 on sheet 1, lines 65537 to 131072 on sheet 2 etc... Thanks for any feedback & have a great weekend! Joel |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split a text file with more than 65536 lines over many worksheets
Hi
Upgarde your MS-Office to Office 2007 is the best possible solution. Regards Rajender Soni On Jul 16, 9:37*pm, "Harald Staff" wrote: Adding to Dave, you might consider an upgrade to Excel 2007 or 2010 where you have 1million rows to work with. Best wishes Harald "jo77" wrote in message ... Hi everyone, I would like to process a text file with more than 65536 lines. Is there any possiblity to do that with Excel ? Either to do it in many iterations (like import lines 1 to 65536, then 65537 to 131072, and so on) or to import it once and split lines 1 to 65536 on sheet 1, lines 65537 to 131072 on sheet 2 etc... Thanks for any feedback & have a great weekend! Joel- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split a text file with more than 65536 lines over many worksheets
On 16/07/2010 13:23, jo77 wrote:
Hi everyone, I would like to process a text file with more than 65536 lines. Is there any possiblity to do that with Excel ? Either to do it in many iterations (like import lines 1 to 65536, then 65537 to 131072, and so on) or to import it once and split lines 1 to 65536 on sheet 1, lines 65537 to 131072 on sheet 2 etc... Thanks for any feedback& have a great weekend! Joel http://www.cpearson.com/excel/ImportBigFiles.aspx |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split a text file with more than 65536 lines over many worksheets
http://www.cpearson.com/excel/ImportBigFiles.aspx Thanks everyone for your feedback. Upgrading to Excel 2007 would be an idea, but I'm not the one deciding it in my firm.... I'll have to wait a little bit... Thanks ManicMiner17 for the link, I'll study & try this, sounds interesting. Have a nice day ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reading in text file that is more than 65536 rows | Excel Programming | |||
Can I go beyond 65536 lines in a file? | Excel Discussion (Misc queries) | |||
Importing Text File with more than 65536 rows | Excel Programming | |||
Importing a large text file (65536) | Excel Programming | |||
export a text file which more than 65536 rows into excel | Excel Programming |