Access Error "To many fields defined" when exporte

[dforgacs]

I'm attaching my code that exports the results of a query to excel.
I get an error of "To many fields defined" when I run this code.
I first thought it was a query problem and repaired and compacted Database but
that didn't help. On further investigation it was failing during the export to
excel. Let me know if you need more information. Help!
Thanks!
Dan

On Error GoTo cmdExportReport_Click_Err

DoCmd.TransferSpreadsheet acExport, 8, "RepairOpsBestPractices",
"R:\fcsd\SLTS Extract Database\OutputFiles\RepairOpsBestPracticesReport.xls",
True, ""
DoCmd.Close acForm, "frmElmStpsBestPractices"
Beep
MsgBox "The Repair Operation Best Practices Report has been exported into
Excel. Please go to your specified path to view to report. Thank you!",
vbOKOnly, ""

cmdExportReport_Click_Exit:
Exit Sub

cmdExportReport_Click_Err:
MsgBox Error$
Resume cmdExportReport_Click_Exit

 

[SydneyGeek]

How many fields are there in the query? Access has a query field limit of 255 -- see link -- so, if you exceed that, the routine will fail.

Denis

 

[Andrew Fergus]

Hi
Have you tried deleting the target spreadsheet and re-running your code?
Andrew

 

[dforgacs]

Access Error "To many fields defined"

Fields checked to show is 7, total in query is less than 20

I Deleted the target file and that fixed it! The error didn't come up and the file has the data in it. Thanks so much!
Daniel Forgacs