Importing Large List

[marcrobin2004]

How do I import a list that is over 200,000 records? I can bring in 65000
records but no more.

 

[Frank Kabel]

Hi
65536 rows is the maximum for one spreadsheet. above that you ned to
split the data on several worksheets.
One workaround to do this: Split the source file with your favourite
text editor to several files and import them individually

--
Regards
Frank Kabel
Frankfurt, Germany

"(e-mail address removed)"

 

[Ken Wright]

If you have that many records then I am assuming they are in database format, in
which case if you have Access you could dump them in there and then query them
from Excel with a Pivot Table or just an ordinary MSQuery. You may even be able
to query them from Excel right where they are now, but it depends on where they
are stored.

Really depends what the data is and what you want to do with it, or get out of
it.