Field Truncation

  • Thread starter Thread starter Tom
  • Start date Start date
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
 
Rick

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

any other suggestions?

Tom
 
Tom said:
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
Click to expand...

Just a wild guess, are there some line feeds, carriage returns etc.?
 
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
 
Tom said:
Joseph

Unfortunately no.
Click to expand...

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
Click to expand...

Just those with MORE than 255. That's interesting. I have not idea
what it means, but it is interesting.
 
You're welcome. I got burned on this exact issue this week for a database
that I support.
 
Back
Top