Import data files larger than one spreadsheet maximum?

We are trying to import a very large (e.g., 1.4 million rows) data file into
Excel. This exceeds the row limit in Excel. Is there a solution without going
to Access that would permit creating sequential; i.e., the data could span or
be linked across multiple spreadsheets.
Thank you,
Bob

Bob

It cannot be done easily... what are you trying to achieve? If it is a
final summary report, then consider using ODBC from your data source into an
Excel pivot table. I bring 250,000+ each week and it works great.

If you are just looking to bring in flat data...honestly... you have the
wrong tool. You should look at Access (At least)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Bobby Joe Mo" <Bobby Joe Mo@discussions.microsoft.com> wrote in message
news:A79D3712-A8B5-4072-BD52-9106DA8C51D1@microsoft.com...
> We are trying to import a very large (e.g., 1.4 million rows) data file
> into
> Excel. This exceeds the row limit in Excel. Is there a solution without
> going
> to Access that would permit creating sequential; i.e., the data could span
> or
> be linked across multiple spreadsheets.
> Thank you,
> Bob