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