Field Truncation

T

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
 
T

Tom

Rick

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

any other suggestions?

Tom
 
T

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
 
K

Ken Snell [MVP]

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