"Too many fields defined" when exporting using Transferspreadsheet

[BillyB]

I get the message above when using Transferspreadsheet method in an maco to create an excel spreadsheet from a query. When I run the query by it's self, it runs fine. If I use the Outputto method, it creates the spreadsheet fine as well. The difference between Outputto and Transferspreadsheet method appears to be that the transfer does not request a confirm to overwrite an existing file but the Outputto does. I do not want the overwrite message.

I am also just curious as to why it works some ways an not others. I have looked this up on many different databases and the only thing I found was to compress the database (which I did and it did not help).

Any thoughts from the very learned forum?

Thanks

Bill

 

[pdx_man]

How many fields are you using? More than 127?

 

[BillyB]

There are 26 fields

 

[mansur]

Too many fields defined error

Sometimes you get this error when the excel file to which you are trying to export already exists. Try deleting this file through code or manually in Windows explorer and try again.