How to export >65k Rows to excel 2010 from Access 2010

[Johin.b]

Hello All,

Kindly help me export a filtered table which has 86k rows to excel.
Access restricts the export to 65k rows. I checked google and few have suggested to use ODBC connection.

Since I am new to this can some one help me with step by step guidance or suggest me a different solution to export these rows to excel.

I user office 2010 in win 7



Thanks in Advance.
Joe

[pbaldy]

What code are you using?

[Johin.b]

I am not using any codes as I do not know VBA. Got a couple of tables in Access 2010 which has more than 65k rows and need it exported to an excel sheet.

[pbaldy]

Not sure what the issue is then. I just used the Export option on the External Data tab to export a table with 240k records and it worked fine. Did you specify xls instead of xlsx perhaps?