Macro to Export Spreadsheet; Keeps Failing

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

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---
 
Not sure what was going on yesterday, but it appears to be working now.
Thanks to all who looked at this post.
Regards,
Ryan---
 
Back
Top