I don't believe you can. Since you posted in Programming, you could use ADO
to get your recordset and then break it yourself:

http://www.erlandsendata.no/english/...php?t=envbadac
http://www.rondebruin.nl/accessexcel.htm

--
Regards,
Tom Ogilvy




"mdengler" wrote:


I'm currently able to export query results to an Excel file via the
querytable method. It is working great... and also very fast, but it
limited to 65xxx records. Is there any way for me to use a querytable
and to programmatically spill over to additional worksheets should I
exceed the Excel 65xxx threshold?

Examples would be appreciated. Thanks.


--
mdengler
------------------------------------------------------------------------
mdengler's Profile: http://www.excelforum.com/member.php...o&userid=32030
View this thread: http://www.excelforum.com/showthread...hreadid=526823