Macro to Export Spreadsheet; Keeps Failing


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---
 
Ad

Advertisements

R

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---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top