Access to Excel Export

[jimmidopolus]

Don't think this topic has been covered as have read quite alot of the site!

Question is regarding exporting over approx 65k records which is above excel's row limit. Current I warn the user and then give the option of exporting the first 65k.

Is there a better solution, for example, being able to write to another sheet so all records are exported (e.g. 150k records would appear over 3 sheets).

Thanks for any help,

james

 

[TelcoBT]

Not sure if this maybe a registry issue, my DB only exports 32K records before complaining and aborting the export - try Microsoft sites.