TransferSpreadsheet - Too many fields?

  • Thread starter Thread starter Nick via AccessMonster.com
  • Start date Start date
N

Nick via AccessMonster.com

Hello,

I'm having a problem with the TransferSpreadsheet method in VBA. In my code,
I create a table at run-time, fill the table data, then export the table to
an Excel spreadsheet. This all worked fine until about an hour ago, when I
changed the exported table from having 12 fields to having 29 fields. Now, I
always get error 3190, "Too many fields".

My worry is that the TransferSpreadsheet will only support a certain number
of fields, and I am over that limit. Could this be the problem?

Otherwise, could anyone give any possible solutions?

TIA,

Nick
 
I love posting something, then finding a solution in the next minute or two...


For anyone who was wondering, (I believe) the problem was caused by my
forgetting to add in a Recordset.Close before I used the TransferSpreadsheet
method. I guess that by not closing the recordset, I somehow was pushed over
the 255 field limit.

If anyone has an alternate explaination for this, I would be glad to hear it,
just to be sure I understand the source of the error for future developments.

Thanks!

Nick
 
Back
Top