Too many rows on expot to excel

[vmon]

Output to excel 5.0 vs 2000 specificaiton

I have the following code and I am getting an error that says there are too many rows. The export is sending about 17,000 rows. I am using A2K - ADP with SQL Server 2k backend. Problem is Access uses Excel 5.0 as specification when outputting for backwark compatitbility and has a limit of 16,384. Is there a way to specify Excel 2000 specification for outputting records which has a 65,000 row limit?

DoCmd.OutputTo acOutputTable, "twrkOrderReleaseReport", acFormatXLS, strPath & strFile, False

Thanks,
vmon

 

[FoFa]

I have not run into that, but if you don't find a solution, you could output a CSV file that Excel reads pretty good also.

 

[Jacob Mathai]

Can you try Transferspreadsheet?

 

[vmon]

Nailed it. Try.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tableNameHere", strPath & strFile