the short answer is “no, you cannot make this a million row spreadsheets.”
you have to make multiple spreadsheets in the book. in this way, you can use a counter to find the magic number of 65,536 records and then start a new spreadsheet each time the counter hits this number.
then in the last spreadsheet (or the first, once you figure it out) you can have links that show the totals for each spreadsheet and then the grand total(s).
if however you want to transfer something like your database, then you have to follow the same formulat for writing to and from the spreadsheet(s) in the workbook.
Excel 2007 only support 65536 rows per sheet, which is the problem that you are hitting. To put more rows than that into a single Excel sheet you would need to upgrade to Excel 2010 (as well as the rest of office probably).
Hi, i have installed xl 2010 with 1 million rows but when i download from AS400 then data stop at 65,xxx