Output To Method Runtime Error

[tekvb1977]

I have table called "North Central Table". This table has around 30,000 records. When I try to output this table to MS Excel, I get the following error:

No records limit exceeded.

DoCmd.OutputTo acOutputTable, "North Central Table", acFormatXLS, "C:\Documents North Central.xls", False


I know Excel can take 64,000 records. Why I am getting this error when my table has only baout 30,000 records. Any thoughts will be highly appreciated!

Thanks,

J

 

[PHV]

Have you tried the TransferSpreadsheet method instead ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886