How can I have more than 64000 rows in one sheet?
 

I want to import an access database in one excel sheet, it requires 200.000
rows. Any suggestions?

"blafblaf" wrote in message
...
I want to import an access database in one excel sheet, it requires 200.000
rows. Any suggestions?

Hi BlafBlaf,

The current worksheet row limit of 65536 is not expected to be increased in
the immediately foreseeable future.

To import your database to Excel, it would therefore be necessary to pass
64k tranches to each of four worksheets.

This however. begs the question as to why you would want or need to do this.

---
Regards,
Norman

This is not possible in Excel.
If it must go into a spreadsheet, Quattro Pro offers up to 1 million rows.
If you want to stay in Excel, you'll need to summarize the data into a
PivotTable or split it into multiple sheets.

tj

"blafblaf" wrote:

I want to import an access database in one excel sheet, it requires 200.000
rows. Any suggestions?

blafblaf wrote:
I want to import an access database in one excel sheet, it requires
200.000
rows. Any suggestions?
Summarize the data in Excel e.g. using a pivot table.

Jamie.

--