Does anyone know the row limit for the docmd.outputto outputing to xls?
im in access 2000 and I do think that Im having a version error with it not letting me export enough data. any info would be great
I know this post is old, but it's the first link returned by Google, so I thought I would provide my fix. I had the same issue, and it's true, you can use TransferSpreadsheet or TransferText to export a larger number of rows, but you lose the formatting provided by OutputTo. I have access 2007 and I also got this error, so instead of using acFormatXls, I used "Excel 97 - Excel 2003 Workbook (*.xls)".