I have a temp table that loads data to Excel
The problem is that it only loads to around 65,000 rows.
I tried changing "acSpreadsheetTypeExcel9" to Excel12 and Excel14, with .xlsx, and it gives me the error message in the title of this post.

I really need it to be able to get more than 65,000 rows.
Does anyone know how I can fix this?

Code:
    Dim outputFileName As String
    Dim path As String
    path = Environ("HOMEPATH")
    outputFileName = path & "\Desktop\SummaryReport_" & Format(Now(), "yyyyMMdd") & ".xls"
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel19, "TempModelsSUM", outputFileName, True
    Set oWB = oExcel.Workbooks.Open("C:" & outputFileName)
    Set oExcel = oWB.Parent