I want to import an access database in one excel sheet, it requires 200.000 rows. Any suggestions?
B blafblaf Jan 16, 2005 #1 I want to import an access database in one excel sheet, it requires 200.000 rows. Any suggestions?
N Norman Jones Jan 16, 2005 #2 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.
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.
T tjtjjtjt Jan 16, 2005 #3 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
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
