Number of rows in a worksheet

[iorrasnet]

I have a very large data file. It has 110,000 records approximately.
want to import it into an excel worksheet. I did so using the Impor
Text function and defining the field widths with !.

Now the most I can seem to import onto a worrksheet is approximatel
65,500 records. The wizard then advises me to import the rest ont
another data sheet, excluding the data already imported on to the firs
sheet.

When I try to do this, the wizard will only allow me to exclude th
first 32,000 records from the second import and then will only impor
approxiately 32,000 more records. In effect the second impor
duplicates the second half of the first import (roughly) and the net
effect is to leave 44,500 records unimported. (ie 110,000 less th
first import of 65,500. The second import is only duplicating half o
the first import).

So ? What can i do ?

Does anyone know how I can exclude more than 32,000 records from th
second import. The actual error message reads "Invalid Integer" if
enter any value above 32,000 approx in the wizard field for the record
to be excluded.

OR

Is there anyway of making the first data sheet bigger ie up to 110,00
rows approx so that all of the data comes in at one import ??

OR

Is there something obvious that I have missed.

I am running Windows 98

Tk

 

[Dave Peterson]

I'd use my favorite text editor and split the text file into smaller pieces.

Then import them separately.

Or you could use a macro that imports each line:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596
XL: Importing Text Files Larger Than 16384 Rows
(written for xl95, but has a note to change stuff for xl97+)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[iorrasnet]

Thanks Dave will try that

Iorrasne