Importing Information into Microsoft Project
You can bring information into Microsoft Project from another application and another file format by importing it. Importing converts another application's file format into the Microsoft Project file format. You start an import process by simply using the File, Open command.
To import data to Microsoft Project, follow these steps:
1 In Microsoft Project, click File, Open.
2 In the Files of Type list of the Open dialog box, click the file format of the file you are importing; for example, Microsoft Access Databases (*.mdb), or Text (tab delimited) (*.txt).
3 Browse to the drive and folder that contain the file you want to import.
4 Click the filename of the file you are importing and then click the Open button.
5 Read the Import Wizard welcome page and then click Next.
6 On the Map page, select the New Map option. Click Next.
7 On the Import Mode page, select how you want to import the data (see Figure 16-21). Click Next.

How do you want to import this file?
C* As a new project
C Append the data to the active project C Merge the data Into the active project
Help
Figure 16-21. Select how you want the imported data to be brought into Microsoft Project.
8 On the Map Options page, under Select The Types Of Data You Want To Import, click the Tasks, Resources, or Assignments check box as appropriate. Click Next.
You see separate Mapping pages for each data type you select on this page.
9 On the Mapping page, complete the fields to specify the information to be imported. In the To: Microsoft Office Project Field column of the table, specify how fields from the source application are to map to specific Microsoft Project fields (see Figure 16-22). Any unmapped data appears in red and will not be imported. Click Next.
Import Wizard - Resource Mapping
Map Resources Data Source database table name:
|
XM| Textl |
VS | ||||||||||||||||||||||||||||||
|
From: Database Field |
To: Microsoft Office Project Field |
Data Type | |||||||||||||||||||||||||||||
|
ContactsID |
ID |
INTEGER | |||||||||||||||||||||||||||||
|
FirstName |
(not mapped) |
VARCHAR | |||||||||||||||||||||||||||||
|
LastName |
Name |
VARCHAR | |||||||||||||||||||||||||||||
|
OrganizationName |
Group |
VARCHAR | |||||||||||||||||||||||||||||
|
DepartmentName |
¡Mil ▼ |
VARCHAR |
Insert Row Delete Row Insert Row Delete Row
| ||||||||||||||||||||||||||||
Post a comment