Microsoft KB Archive/69590

Field Names May Be Truncated When Saved in dBase Format

PSS ID Number: Q69590 Article last modified on 11-16-1994

1.00

WINDOWS

= SUMMARY =

When you export a project from Project for Windows to a dBASE format, the table field names may be truncated, causing confusion between fields that have similar names in Project.

= MORE INFORMATION =

If you export fields such as Scheduled Start and Scheduled Finish in a dBASE format, both field names are truncated to Scheduled because dBASE only supports field names of up to 10 characters. Because Project for Windows uses its default field names when it exports, changing the field titles by choosing Define Tables Under the Table menu will not alter these exported field names.

= WORKAROUND =

From the Options menu, choose Set Plan to copy the Scheduled Start and Scheduled Finish fields into one of the other available fields such as Start1 and Finish1. Exporting these fields will produce two distinct field names with the original data you wanted to export.

Project for Windows version 3.00 exports shortened Dbase compatible field names. For example, version 1.0 creates a field name for Scheduled Start that says “Scheduled” (10 total characters) whereas version 3.0 creates a field name for Scheduled Start as “Sch_Start”.

KBCategory: kbother KBSubcategory:

= Additional reference words: 1.0 =

Copyright Microsoft Corporation 1994.