View Full Version : Import 'Notes' or 'Textn' from Excel and it Truncates...


NascarFan
03-20-2006, 11:36 PM
When I try to Import data from excel the 'Textn' truncates and I understand
that it is only 255 characters. The 'Notes (Task Notes)' also truncates but
I can cut and paste and it holds all the information. Any idea on why it
would trunchate on the import at 255 characters when it seems to have the
ability to hold more? Thank you in advance. This if from Excel 2002 to MS
Proj 2003.

John
03-21-2006, 02:13 AM
In article <37E285EF-8C65-4F53-AA9C-02A3BFA455FF@microsoft.com>,
NascarFan <NascarFan@discussions.microsoft.com> wrote:

> When I try to Import data from excel the 'Textn' truncates and I understand
> that it is only 255 characters. The 'Notes (Task Notes)' also truncates but
> I can cut and paste and it holds all the information. Any idea on why it
> would trunchate on the import at 255 characters when it seems to have the
> ability to hold more? Thank you in advance. This if from Excel 2002 to MS
> Proj 2003.

NascarFan,
I can't say that I have a definitive answer but the same thing happens
when the Notes field is exported from Project to another application
using an export map. It is simply a limitation of the mapping function.
As you note, a copy and paste into the Notes field via the Notes tab of
the Task Information window will allow the full string. Likewise, if VBA
is used to make the transition (Excel to Project or vice versa), the
full sting will be translated.

John
Project MVP