Microsoft KB Archive/60989

= PRJ: Pasting Information into Project from Another Application =

Article ID: 60989

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Project 2000 Standard Edition
 * Microsoft Project 98 Standard Edition
 * Microsoft Project 4.1 Standard Edition
 * Microsoft Project 1.0 Standard Edition
 * Microsoft Project 3.0 Standard Edition
 * Microsoft Project 3.0a
 * Microsoft Project 4.0 Standard Edition
 * Microsoft Project 1.1 for Macintosh
 * Microsoft Project 3.0 for Macintosh
 * Microsoft Project 4.0 for Macintosh

-



This article was previously published under Q60989



SUMMARY
When pasting information into Microsoft Project from another program, the columns of information that you are copying must match the columns of information in the table in Microsoft Project that you are pasting into. Like Microsoft Excel, the information will be pasted into Microsoft Project starting at the upper-left cell of a selection. Unlike Excel, the remainder of a selection will be ignored and pasted information will merge into Microsoft Project, deleting the overwritten information.

Microsoft Project pastes information into the active table in a column for column format. It will take the first column of information from the Clipboard and try to put it in the first column of information in the active table. If it doesn't match, the information is discarded and the next column is processed until all the information is used from the Clipboard.



MORE INFORMATION
If you are pasting information into the default entry table in Microsoft Project, the information must be set up in the same way the entry table is in Microsoft Project (for example, ID, Name, Duration, etc.). If you leave out a column, the information that gets pasted in will not be what you expected.

Example
In Excel, set up a table that looks like this:      A        B    --- Task 1       2d Task 2       3d Task 3       4d Copy this information to the Clipboard.

Paste the information into the default entry table in Microsoft Project.

Your results in Microsoft Project will look like the following:   ID    Name     Duration 1     2d          1d 2     3d          1d 3     4d          1d Microsoft Project was looking for the ID column to be the first column of data that it received; instead, it saw the Names and put them in the ID column. It then took the durations and put them in the Task column and entered in the default durations when it didn't see a duration specified.

You always need to include the first column of information when pasting information into Microsoft Project even if that column is in Microsoft Project by default.

The information that would have worked in the above example is as follows:   A       B        C   --- -- - 1  Task 1       2d 2  Task 2       3d 3  Task 3       4d This information would come across correctly when pasted into Microsoft Project.

Additional query words: prj2000 1.0

Keywords: kbhowto kbinterop KB60989

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.