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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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.
 
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 said:
I want to import an access database in one excel sheet, it requires 200.000
rows. Any suggestions?
Click to expand...
Summarize the data in Excel e.g. using a pivot table.

Jamie.

--
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to open Excel sheet with more than 64000 lines 3
When will Excel expand the 64000 row limit? 3
dynamic data range in pivot tables excel 2007 1
Help needed with lookup tables.. 5
importing accounting data am limited to 16384 line - why? 2
Cannot remove empty rows 8
Need to merge worksheets - Excel 2003 0
Multiple Rows of Sheet Tabs 2

Back
Top