DoCmd.TransferSpreadsheet Row Limit? RRS feed

  • Question

  • Hi Folks -

    I have a query setup that returns 145k lines.  If I export the query manually (right click -> Excel export)  I get the full results.  However when I leverage DoCmd.TransferSpreadsheet within a Function, it limits my output.  Is that expected?

    If so, is there a way to get around this? Am I better off creating an export and calling that instead of using DoCmd.TransferSpreadsheet?

    Thank you!

    Thursday, August 6, 2020 11:29 PM

All replies