Export: Error 3190 - "Too Many Fields Defined" (1 Viewer)

Hi

I have used some code to export a query to a spreadsheet...

For some reason i get the error msg "too many fields defined".
I understand there is max number of columns for a spreadsheet - however, the data being exported does fit easily into a spreadsheet. (when pasted)

???

rgrds

Are you trying to query more than 255 fields?

If so, STOP IT!

Are you trying to 'update' query more than 127 fields?

If so, STOP IT!

If not, Access may 'think' you are.

Try a Compact and Repair.

Also, are your fields 'too full'? There is a character limit per record.

If not, I'd try saving the table, make sure you get all the data, and then try using the copy of the table in the query.

HTH

the table was only about 80 columns wide..

i tried to repair the database... no luck there

so i deleted the spreadsheet and created a new one... this appears to have solved the problem..

Thanks