Field Truncation

[Tom]

Using Access 2002 when exporting a table to excel we are now getting a
ExportError table being produced with the error described as Field
Truncation. The Field name is Project, which is a memo field, and a row
number. We note that only some of the records exported are listed in this
error table.

Having looked at the original data in the Memo field for the listed row
numbers we are unable to identify anything specific that is different - some
of the memo fields listed have less than 255 characters some have more.

Any suggestions as to what the problem is or what we should be looking for
would be appreciated

TIA

Tom

 

[Rick B]

This same question was asked and answered earlier today. Do a search.

 

[Tom]

Rick

Had already that post but we are already using the DoCmd.TransferSpreadsheet
method

any other suggestions?

Tom

 

[Joseph Meehan]

Using Access 2002 when exporting a table to excel we are now getting a
ExportError table being produced with the error described as Field
Truncation. The Field name is Project, which is a memo field, and a
row number. We note that only some of the records exported are listed
in this error table.

Having looked at the original data in the Memo field for the listed
row numbers we are unable to identify anything specific that is
different - some of the memo fields listed have less than 255
characters some have more.
Any suggestions as to what the problem is or what we should be
looking for would be appreciated

TIA

Tom

Just a wild guess, are there some line feeds, carriage returns etc.?

 

[Tom]

Joseph

Unfortunately no.

Using a test table with the same fields & names & the following code:

DoCmd.TransferSpreadsheet acExport, , "SearchDbToExcelQ",
"C:\Temp\test.xls", True

we notice that any record that has has more than 255 characters will be
entered to the ExportError table

Tom

 

[Joseph Meehan]

Joseph

Unfortunately no.

It was worth a try. Sorry it did not help.

Using a test table with the same fields & names & the following code:

DoCmd.TransferSpreadsheet acExport, , "SearchDbToExcelQ",
"C:\Temp\test.xls", True

we notice that any record that has has more than 255 characters will
be entered to the ExportError table

Just those with MORE than 255. That's interesting. I have not idea
what it means, but it is interesting.

 

[Ken Snell [MVP]]

I assume that SearchDbToExcelQ is a query. By any chance, are you using a
calculated field to export the memo field's contents? If yes, see this
Knowledge Base article:

Exported Query Expression Truncated at 255 Characters
http://support.microsoft.com/default.aspx?scid=kb;en-us;207668

 

[Tom]

Ken

Thank you - that was spot on!

Tom

I assume that SearchDbToExcelQ is a query. By any chance, are you using a
calculated field to export the memo field's contents? If yes, see this
Knowledge Base article:

Exported Query Expression Truncated at 255 Characters
http://support.microsoft.com/default.aspx?scid=kb;en-us;207668

 

[Ken Snell [MVP]]

You're welcome. I got burned on this exact issue this week for a database
that I support.