Mark

Often users are doing something else with the data afterwards, i.e.
summarising, filtering, etc. After all it is impossible to 'read' 900k
records/rows.

If the above is true then consider bringing the data into Excel from the
external source as a pivot table (DataPivot table or pivot chart report...)

I regularly bring in 500k records this way, summarised to a few rows (You
can currently have up to around 16k)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Mark" wrote in message
...
I wish to import data into Excel that is typically 90K rows long and could
go
to as much as 900K. # of Columns is only say 20 or so.
is there any way to remove the 65536 row limit so the whole data set can
be
imported at once?
Alternatively, is there some snippet of code or idea to import the data
into
multiple sheets?
Many thanks for any advice.