How to export more than 65000 rcds from Access to Excel 2007

[SKV]

I have a table with 500,000 rcds and on exporting it only exports 65000 rcds.
Please advice

Thanks
SKV

 

[boblarson]

I pasted the code in the module

So, you didn't answer the part about how did you call it and what error happens when you try to run it.

 

[junkforhr]

Hi,

Very new to Access and still a noob at it, but, I have had this problem as well.

A simple answer if you are trying to export to Excel 2007 from Access 2007, is to NOT check the "Export data with formatting and layout" option. I have exported 900,000 rows of data to Excel by doing this.

Not sure if this is what you're after,but, I hope it helps