Microsoft KB Archive/122563

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

= 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.

  From the File menu, choose Save As.   Change the File Type to dBASEIII or dBASEIV (note of the table that’s used).   From the File menu, choose Open. Under List Files Of Type, select one of the dBASE (*.dbf) file formats.   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.