export to exel

  • Thread starter Thread starter ram8595
  • Start date Start date
R

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
 
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.
 
Back
Top