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

 

[bhicks11 via AccessMonster.com]

I responded to this in Queries.

Bonnie
http://www.dataplus-svc.com

 

[Keith Wilby]

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

Please don't multi-post!