how export access table to excel

[Guest]

The access table has 50K rows, but I can't export all rows to excel.

 

[Ken Snell \(MVP\)]

If you're using File | Export method, then the limit is 16,384 rows.

Use TransferSpreadsheet (macro or VBA) to do the export; you can then
specify the current version of EXCEL and get 65,536 rows (actually, 65,535
plus the row to show the field names).