export to exel

[ram8595]

is there any query where in we could extend the no of rows one can
export into exel from Access. now when i export a table from access
into excel it pastes only 65536 rows. is there any way i can have exel
take more than 100000 records. pls let me know

 

[Ken Snell \(MVP\)]

65536 is the maximum number of rows for a worksheet in EXCEL 2003, 2002, and
2000. To get more rows, you'll need to export to EXCEL 2007, using ACCESS
2007.