Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
exclude data already imported in excel
As the subject says...
when importing a text file with more then 65536 records i get this message: "the text file contains more data than will fit on a single worksheet. you can import the rest of the data by repeating the import operation on another worksheet and using the text import wizzard to exclude data already impotred in excel" but i carnt figure it out. has anyone got the answer? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
exclude data already imported in excel
A spreadsheet is not infinite in size; it maxes out at 65,536 rows, so you
will not be able to get all of your data onto one worksheet. The message is telling you that if you want to store the rest of your data you'll have to put it in a separate worksheet (tab). The way you would bring the rest of your data into excel (in the second worksheet) is to open the second (blank) worksheet, then select the Data Import External Data Import Data options, then when point Excel to the text file. Then the Import Wizard appears, and provides you with the opportunity to customize the import. Since you've already stored the first 65,536 rows in the first tab you'll want to skip those rows and begin with row 65,537 in this worksheet, so at the prompt "Start import at row:" you'll enter 65537; you'll be able to store your next 65,536 rows in the second tab, and repeat as needed. A word of caution about performance in a spreadsheet this large - it's going to be a bear, and be sure to save often. Hope this helps... "Ashley Bowles" wrote: As the subject says... when importing a text file with more then 65536 records i get this message: "the text file contains more data than will fit on a single worksheet. you can import the rest of the data by repeating the import operation on another worksheet and using the text import wizzard to exclude data already impotred in excel" but i carnt figure it out. has anyone got the answer? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
exclude data already imported in excel
I attempted to do the operation to continue my import on to the next worksheet, but I get the error "Integer is not valid". Office 2003 importing text file with more line entries than 65535. I received the message regarding the possibility of excluding data that was already imported, but I don't see the option available. -- corefactsva ------------------------------------------------------------------------ corefactsva's Profile: http://www.excelforum.com/member.php...o&userid=30115 View this thread: http://www.excelforum.com/showthread...hreadid=487605 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Sorting imported .txt data in Excel | Excel Worksheet Functions | |||
Linking the data from one excel to another | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |