Macro to Export Spreadsheet; Keeps Failing

Macro to Export Spreadsheet; Keeps Failing

Post by cnlndXk3Mj » Wed, 11 Jun 2008 08:12:01


I am trying to export a Query to a SS, and I鈥檓 getting a message that says
鈥楾oo 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---



--
RyGuy
 
 
 

Macro to Export Spreadsheet; Keeps Failing

Post by cnlndXk3Mj » Wed, 11 Jun 2008 23:27:01

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

--
RyGuy