Project: Values/Text Truncated When Saved in dBASE Format
  
PSS ID Number: Q122563
Article last modified on 12-13-1994
 
3.00 3.00a 4.00
 
WINDOWS
 

--------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Project for Windows, version 3.0, 3.0a, 4.0
--------------------------------------------------------------------
 
SYMPTOMS
========
 
In Microsoft Project for Windows, when you save in a dBASE file format
(.DBF), field values may be converted incorrectly depending on the width of
the column in which they are located.
 
Note that this issue occurs only when you save a file and open it in a
table where column widths are too narrow to accommodate the incoming data.
 
WORKAROUND
==========
 
To work around this problem, make sure that column widths are wide enough
to accommodate the largest value before you save the project in dBASE
format.
 
MORE INFORMATION
==================
 
Steps to Reproduce Behavior
---------------------------
 
1. In a new project, type in a task name "abcdefgh" (without the quotation
   marks), and set the column width to 5.
 
In the Name column, only "abcde" should be visible.
 
2. From the File menu, choose Save As.
 
3. Change the File Type to dBASEIII or dBASEIV (note of the table that's
   used).
 
4. From the File menu, choose Open. Under List Files Of Type, select one of
   the dBASE (*.dbf) file formats.
 
5. Select the file you saved in step 3, and be sure to use the same table.
 
In the Name field, the task name is permanently truncated to "abcde." The
other characters in the task name have been deleted.
 
KBCategory: kb3rdparty kbusage
KBSubcategory:
 
NOTE: This same behavior occurs in some of the numeric fields.
=============================================================================
Copyright Microsoft Corporation 1994.
