You can't, it is Excel sheets limited to 65 536 rows. AFAIK only
spreadsheet what can work with huge sheets is Quattro Pro 9
and newer. Sheets can be 1 million rows and 18 278 columns.
You probably must use database program.
Toomas
----- Original Message -----
From: "Jenny Hurley" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Monday, January 26, 2004 3:09 PM
Subject: [PCSOFT] Importing External Data to Excel
Subject: Importing more than 65,556 rows into EXCEL
I have a file with one million rows. I can import 65,556 rows and that is the
limit for a page in Excel. How do I import the remainder files into Excel?
Thanks, Jenny
PCSOFT maintains many useful files for download
visit our download web page at:
http://freepctech.com/downloads.shtml
Curious about the people moderating your
messages? Visit our staff web site:
http://freepctech.com/staff.shtml
|