Home |
Search |
Today's Posts |
#1
|
|||
|
|||
opening text files that have more rows than 65536
Does anyone know how to get excel to add another worksheet to the workbook to
open a text file that has more rows than the excel limit of 65536? Currently, I am just cutting from the text file in notebook and pasting into multiple worksheets. I keep thinking there must be a faster way... |
#2
|
|||
|
|||
See
http://support.microsoft.com/default...;EN-US;q120596 "rondajoy" wrote: Does anyone know how to get excel to add another worksheet to the workbook to open a text file that has more rows than the excel limit of 65536? Currently, I am just cutting from the text file in notebook and pasting into multiple worksheets. I keep thinking there must be a faster way... |
#3
|
|||
|
|||
If you import the data using the <data<Import external data and selecting
your file One of the entries is "start import at row" this is not perfect and it often still wont go far enough but it at least lets you go to another sheet I have had it tell me different max numbers for the allowable start point before. I have also had people write script for me to divide the data sets into smaller chunks and have used other programs such as Jump which would allow more rows and just exported the size chunks I needed. "rondajoy" wrote: Does anyone know how to get excel to add another worksheet to the workbook to open a text file that has more rows than the excel limit of 65536? Currently, I am just cutting from the text file in notebook and pasting into multiple worksheets. I keep thinking there must be a faster way... |
#4
|
|||
|
|||
Another approach:
If you have MS Access, I'd recommend you import your text file there first, allowing Access to create a key column for you. You can then do either of two things: 1st way: use Excel's DataImport External DataNew Database Query menu to pull the first 65000 rows into one sheet (using the key column that Access created), then pulling the next 65000 rows into the second sheet, and so on. 2d way: leave all the data in Access and Excel's DataImport External DataNew Database Query menu to pull in only the subsets of data needed for the immediate analysis. 2d way has the advantage of allowing you to quickly & easily select against the entire dataset, rahter than having to worry about data on 2 or more worksheets "rondajoy" wrote: Does anyone know how to get excel to add another worksheet to the workbook to open a text file that has more rows than the excel limit of 65536? Currently, I am just cutting from the text file in notebook and pasting into multiple worksheets. I keep thinking there must be a faster way... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple text files URGENT | Excel Discussion (Misc queries) | |||
importing multiple text files??? | Excel Discussion (Misc queries) | |||
how do I easily convert a single column of text (multiple rows si. | Excel Discussion (Misc queries) | |||
Slow opening files - possible cause and solutoin | Excel Discussion (Misc queries) | |||
increasing the number of rows of a worksheet beyond 65536? | Excel Discussion (Misc queries) |