I am trying to export a table to Excel using transferspreadsheet and I am
running into the "Too many fields defined" error. There are 31 columns in
the table. The export worked previously and it bombed out last night with
the above error. I tried compact and repair and also redid the whole
database from scratch and it still bombed. Any assistance would be greatly
appreciated.

Thanks,
Pat

Pat_RI wrote:

I am trying to export a table to Excel using transferspreadsheet and I am
running into the "Too many fields defined" error. There are 31 columns in
the table. The export worked previously and it bombed out last night with
the above error. I tried compact and repair and also redid the whole
database from scratch and it still bombed. Any assistance would be greatly
appreciated.
>
Thanks,
Pat
>
>

It thinks you are attempting to send more than 255 columns. Maybe
create a temp query on the table and start deleting 1 column at a time
after running the command then run until you find the column that is
causing problems.

Another thing, you can post your Docmd.TransferSpreadsheet line here so
that others can review it and see if you are using an incorrect syntax.

Three More Days
http://www.youtube.com/watch?v=bIYG4wvRXVk