TransferSpreadsheet -- Too many fields defined

[fredalina]

i have 4 crosstab queries which all open correctly without issue. However, when trying to execute DoCmd.TransferSpreadsheet code, it suddenly started producing the "Too many fields defined" error.

The crosstab queries have an ID field followed by one column for each business day within the current month. There are generally 1-2 dozen rows. This worked correctly through the end of June, but in July the error started happening, even with only 12 rows and 3 columns total.

Any suggestions? Thanks!

 

[SOS]

Any suggestions? Thanks!

Yeah, don't use TransferSpreadsheet. Use something like this.

 

[fredalina]

Hi. I'm revisiting this because using the link you provided only transfers over the header line for some reason. Perhaps it's because the queries are crosstab queries? But only the column headings transfer over.

Also, the default is for 3 workbooks, and there are 4 queries that need to be transferred.

Can you help?