trying to output a table to excel

[AmeriSource]

i'm trying to output an access table to excel using the outputto command.My problem is that i can't output more than 11 000 records or so. I need to output about 50000 and it tells me " Run time error 2306 There are too many rows to output bared on the limitations specified by the output format or by Microsoft Access." I know that excel has about 60000 rows in a spreadsheet. Does any one have any ideas on how i can get this table to be exported.
P.S: This has to be automated.

 

[thevillageinn]

I'm not familiar with OutputTo, so I use this instead. I haven't had any issues with record limits, other than the 64,000+ limit of excel.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "TableName", FileName, true, ""

I use this on a command button in cooperation with the common dialog control.

hth
-Dan