Transfer Spreadsheet in Access 2000
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.
Re: Transfer Spreadsheet in Access 2000
Are you specifing a Range? If you do it will fail. Leave it blank for Exporting.
Re: Transfer Spreadsheet in Access 2000
I didn't use a range. Left range blank.
Re: Transfer Spreadsheet in Access 2000
How many fields and are there any special characters in the field names?
Also, do you have a memo field type in the table?
Re: Transfer Spreadsheet in Access 2000
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.
Re: Transfer Spreadsheet in Access 2000
I just tried using the DoCmd.OutputTo acTable command. It seems to work. Perhaps there is a limit to DoCmd.TransferSpreadsheet.
Re: Transfer Spreadsheet in Access 2000
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.
Re: Transfer Spreadsheet in Access 2000
I found this link, but it doesn't specify that there is a limit.
Re: Transfer Spreadsheet in Access 2000
Thank you for the link. It seems even the Do.Cmd Output is truncating the data in some of the fields.
Re: Transfer Spreadsheet in Access 2000
What is the limit that is making it through for the memo? 255, 1024, etc.
Re: Transfer Spreadsheet in Access 2000
Looks like 255. We may just transfer the data as rtf file. I appreciate your time. Thank you.
Re: Transfer Spreadsheet in Access 2000
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?