How to transfer more than 65536 rows from Access to excel 2007

Question

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.

Thanks

Answer 1

What MS Access version do you use?

I suppose it's old and it should also be 2007.

Here's solution for your issue

http://nandeshwar.info/2009/03/02/access-export-to-excel-2007/

and also

http://support.microsoft.com/kb/924681

it looks like that only if you export table/query using right click > Export and have the checkbox cleared, then Access will export succesfully.

Answer 2

Check these links....... i think u will get some useful content...

http://www.eggheadcafe.com/software/aspnet/33875811/export-65536-rows-to-ex.aspx http://www.pcreview.co.uk/forums/thread-3679029.php

Answer 3

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.