Microsoft KB Archive/90163

{|
 * width="100%"|

PRJ: Type Conversion Error Importing Proj File into Access

 * }

Q90163

-

The information in this article applies to:


 * Microsoft Project for Windows, versions 3.0, 3.0a, 4.0
 * Microsoft Access 1.0

-

SYMPTOMS
In Microsoft Project for Windows, you can save your Project file as a text file (CSV or TXT) which can then be imported into a Microsoft Access database. Project files containing WBS (Work Breakdown Structure) codes may not import correctly.

Importing Project files with WBS codes may cause a Type Conversion Failure in Microsoft Access. WBS codes such as 1.1.1 or 2.3.1 cause the task or record to be placed in an error table in Access. This happens because Access interprets the WBS code field to be a numeric field but values like &quot;1.1.1&quot; are not valid numbers.

Workaround 1
Create a table in Microsoft Access, defining the WBS code field as type Text, and then append your Project file to the table rather than creating a new table for your imported data.

Workaround 2
After importing your Project file into an Access database, change the field type from Number to Text, and then copy your WBS codes from the Error table to your database table.

MORE INFORMATION
When Microsoft Access converts the data in your text file, it looks at the value in the first row of data to determine the field data type. Since the first value in the WBS code is the number 1, this field is interpreted as numeric. When reading the data for that field, values such as 1.1.1 cause a data type error resulting in the Type Conversion Failure and all the data for the WBS code field is put into an Error table in Access.

Additional query words: 3.0 Access 1.0 3.00a

Keywords : kbinterop

Issue type : kbprb

Technology : kbAccessSearch kbAccess100 kbProjectSearch kbProject300 kbProject300a kbProject400