Transfer Spreadsheet in Access 2000

[MAB]

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.

[RobDog888]

Are you specifing a Range? If you do it will fail. Leave it blank for Exporting.

[MAB]

I didn't use a range. Left range blank.

[RobDog888]

How many fields and are there any special characters in the field names?
Also, do you have a memo field type in the table?

[MAB]

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.

[MAB]

I just tried using the DoCmd.OutputTo acTable command. It seems to work. Perhaps there is a limit to DoCmd.TransferSpreadsheet.

[RobDog888]

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.

[RobDog888]

I found this link (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/acmthactTransferSpreadsheet.asp), but it doesn't specify that there is a limit.

[MAB]

Thank you for the link. It seems even the Do.Cmd Output is truncating the data in some of the fields.

[RobDog888]

What is the limit that is making it through for the memo? 255, 1024, etc.

[MAB]

Looks like 255. We may just transfer the data as rtf file. I appreciate your time. Thank you.

[RobDog888]

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?