Macro to Export Spreadsheet; Keeps Failing

[ryguy7272]

I am trying to export a Query to a SS, and I’m getting a message that says
‘Too many fields defined’, and then the macro fails. The transfer Type is
Export, the Spreadsheet Type is Microsoft Excel 8-10, the Table Name is
qryCurrentQ, the File Name is C:\Documents and Settings\rs\Desktop\Access
Models\Current.xls, and the Has Field Names is set to Yes.

What could be the problem here?


Thanks,
Ryan---

 

[ryguy7272]

Not sure what was going on yesterday, but it appears to be working now.
Thanks to all who looked at this post.
Regards,
Ryan---