How to transfer more than 65536 rows from Access to excel 2007
How to transfer more than 65536 rows from Access to excel 2007.
There is no limitaion on the part of Excel 2007 as the new version supports much more than 65536 rows in Excel. Limitation is coming on the part of Clipboard. It is not allowing to export or to Copy more than 65536 rows from Access.
Data -> Import?
What's wrong with that? I've used it many times for importing thousands of records.
Just define the data source and import it.
What MS Access version do you use?
I suppose it's old. It should be 2007 or upper.
Here's solution for your issue
it looks like that only if you export table/query using right click > Export and have the checkbox cleared, then Access will export succesfully.
Check these links....... i think u will get some useful content...
Almost certainly this is a timeout or a memory issue. The only PHPExcel limit for worksheets size is 65,536 rows and 256 (IV) columns (when using the Excel5 Writer); or 1,048,576 rows and 16,384 (XFD) columns (when using the Excel2007 Writer).
If you are using PHPExcel Library then You can change this line $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); as $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
Then it allows to write records more than 65536 rows. It works for me.