Exporting Datasheet to Excel

[evhfan2000]

When exporting a data sheet with 800,000 rows of data, 26 columns, Access will only export 65,000~ rows as if it thinks it has limitations of Access 2003 / Excel 2003.

Any ideas how I can "flip a switch" to get this to export properly?

Thanks.

MS Office 2007
Access 2007
Excel 2007

[boblarson]

The easiest way - copy this function from my website (if the datasheet you mean is a form):
http://www.btabdevelopment.com/ts/de...aspx?PageId=47
into a standard module (not form, report, or class module) and then just call it where you want.

If a table or query use this one:
http://www.btabdevelopment.com/ts/de...aspx?PageId=48