i need to import a huge txt file into excel
i need to import a hug txt file into excel but failed because insufficient
rows. is there anyway i could increase rows without using access? |
i need to import a huge txt file into excel
On Sun, 28 Jan 2007 07:36:00 -0000, Adelne
wrote: i need to import a hug txt file into excel but failed because insufficient rows. is there anyway i could increase rows without using access? no, apart from upgrading to Excel 2007 search group for some previous answers on this I think there are was to "read" the file in several stages Of course the right answer shoudl have been - use access -- Steve (3) |
i need to import a huge txt file into excel
I've used this sucessfully in the past
http://www.danielklann.com/excel/imp...files_into.htm or the Microsoft solution which I haven't tried. http://support.microsoft.com/kb/120596 Mike "Adelne" wrote: i need to import a hug txt file into excel but failed because insufficient rows. is there anyway i could increase rows without using access? |
i need to import a huge txt file into excel
I have extensive notes and lots of example code at
http://www.cpearson.com/excel/ImportBigFiles.htm . It will handle importing files of any size, splitting the data across as many worksheets as necessary. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Adelne" wrote in message ... i need to import a hug txt file into excel but failed because insufficient rows. is there anyway i could increase rows without using access? |
All times are GMT +1. The time now is 05:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com