XL2000: "File Not Loaded Completely" Error Message When Running Text Import Wizard (214015)

ERROR MESSAGE

When you use the Text Import Wizard to import a text file, and specify a value of 32,768 or higher in the Start import at row box in step 1, you may receive one of the following error messages:

File not loaded completely.

-or-

Integer is not valid.

NOTE: Microsoft Office 2000 has built-in functionality that allows you to get more information about difficult-to-troubleshoot alerts or error messages. If you want to enable this functionality for this and other error messages in Microsoft Office 2000, please download the Microsoft Office 2000 Customizable Alerts file from the Microsoft Office Update Web site at the following address:

http://www.microsoft.com/downloads/details.aspx?FamilyID=8FBEE1D3-C5BB-4A36-A2F7-DC63DE2A818C

NOTE: If you reached this article by clicking the Web Info button in an error message, you already have Customizable Alerts enabled.

CAUSE

The maximum number of rows you can specify using the Text Import Wizard is 32,767. The maximum number of rows in an Excel 2000 worksheet is 65,536. If you open a text file with 65,536 rows or fewer, all rows of the text file will be imported into one worksheet. However, if you attempt to import more rows than are available in the worksheet, only 65,536 rows of the text file will be loaded, and you will receive one of the error messages described in the "Symptoms" section of this article.

THINGS TO TRY

If your worksheet contains more than 65,536 but fewer than 98,304 rows, you can use the Text Import Wizard to import the text file into multiple worksheets by following these steps:

On the File menu, click Open. Select the text file you want to open and click OK.
In the Text Import Wizard, type or select 1 in the Start import at row box and then click Finish.
The first 65,536 rows of the text file are imported into a worksheet, and you receive the error message, "File not loaded completely." Click OK. Save this workbook.
Repeat step 1. In the Text Import Wizard, select 32,767 in the Start import at row box, and click Finish.
Note that 65,536 rows of the text file starting at row 32,766 are imported into a worksheet. Save this workbook.
You can delete the first 32,770 rows in this workbook because these rows were also imported into the workbook you saved in step 5. Save this workbook.

If your worksheet contains more than 98,303 rows, perform steps 1 through 6 and then follow these steps:

Open the worksheet containing more than 98,303 rows.
Delete the first 98,303 rows.
Save the file, and then import the remaining rows by following steps 1 through 6 again.

Repeat this process until you have imported all the rows in your worksheet. Note that you should make a back up copy of your file before you delete any text from it.