TransferSpreadsheet

[IanT]

I am using the DoCmd.TransferSpreadsheet acExport to export data to a Excel spreadsheet. I am getting a error message saying 'Too many fields defined'. Is there a way to overcome this as in help it says that there are more than 255 fields, but there is only 12.

 

[rglman]

Try a compact and repair...

I had the same problem once before, and it was the result of an indexing error that was corrected by running a "compact & repair".