Printable View
Hi,
I'm using the following DoCmd.TransferSpreadsheet acexport command to take an Access table and create an Excel spreadsheet. I get an error message that says "Too Many Fields Defined". Is there a limit to the number of fields or field sizes?
Thank you.
Are you specifing a Range? If you do it will fail. Leave it blank for Exporting.
I didn't use a range. Left range blank.
How many fields and are there any special characters in the field names?
Also, do you have a memo field type in the table?
There are 24 fields in the table - 7 are memo fields. No special characters in any of the field names. Strange thing is it was working and suddenly it gave us this error message. I removed two memo fields and the process worked. Problem is we need to get this table in its full form over to Excel.
I just tried using the DoCmd.OutputTo acTable command. It seems to work. Perhaps there is a limit to DoCmd.TransferSpreadsheet.
Its got to be either a length issue for an Excel Cell to accept or there could be
some invalid data in one of the records in one or both memo fields.
I found this link, but it doesn't specify that there is a limit.
Thank you for the link. It seems even the Do.Cmd Output is truncating the data in some of the fields.
What is the limit that is making it through for the memo? 255, 1024, etc.
Looks like 255. We may just transfer the data as rtf file. I appreciate your time. Thank you.
No prob. but what if you export it as a textfile and then do a manual import
from Excel? Maybe that way you can get the entire memos. Or maybe Excel
is the one with the limit of 255?