Importing Data from Databases Project Management Help

In large and mid-sized organizations, much of the data project that managers would deem worth importing is housed in databases, The departments that own information, you want to include in your project file-Personnel, Materials Management, Manufacturing, and Purchasing, for example-are big-time database users, Database applications give them a place to store all the excellent information that project managers like you I and I covet.

Upgrading Project Databases

If you saved Microsoft Project 98 projects in a database, you can upgrade the entire database to the Microsoft Project 2000 database format, whether the databases were saved in a Project, Access, or another ODBC format. You can upgrade the existing databases to the original database or another database, The database upgrade utility uses Visual Basic code, so you must set the macro security level to low before you can use the utility. To set the security level, choose Tools >- Macro> Security to open the Security dialog box. On the Security Level tab, choose the Low option, then click OK to close the dialog box. (After running the utility, it’s a good idea to reset the security level to Medium.) Close all open database files; then display the Data base Upgrade toolbar (View >- Toolbar > Database Upgrade Utility).

This toolbar has only one button, Click it to open the Database Upgrade Utility dialog box, In the left pane, choose the database file that contains the projects you wish to upgrade, Click to select individual projects in the file, or click the Select All button to select all projects, In the right pane, choose a target type and location, Select the same location as in the left pane to upgrade the existing database or DSN click the New button to create a new DSN or database file, After setting the source and target information, click Upgrade to create the target database or DSN.

Figure 19.23

Figure 19.23

Importing a Project from a Project Database

Microsoft Project Database (MPD) is a proprietary file format for an Access database, It contains all project data for one or many projects, Project Database is the preferred method of exchanging project data, replacing the MPX format used in Project 4.
To import a complete project from a Project Database:
1. Start Project.

2. Choose File >Open.

3. Use the Look In drop-down list to locate the proper folder and file.

4. Select’ the database and click the Open button The Open From Database dialog box is displayed.

5. On the Entire Project tab select the project you want to import.

Figure 19.24

                           Figure 19.24

6. Click Open in the Import Mapping dialog box to import your data into Project.

Importing Data from an Access Database

Follow the procedure listed as follows to import an entire project from an Access database or to use a predefined data map. To edit or create a data map.
1. Start Project.

2. Choose File > Open.

3. The Files of Type to Microsoft Access Databases (MDB).

4. Use the Look In drop-down.. list to locate the proper folder and database file.

5. Select the file and click the Open button to open the Import mapping dialog box.

6. You can import Entire Projects or Selective Data from Access, If the database you selected contains complete project files, both tabs will be enabled. If not, only the Selective Data tab will be active.

7. To import an entire project, select the project from the list on the Entire Projects Tab and click Open to begin importing data.
OR
To import selected data, select an import map on the Selective Data tab.

8. Click the Edit button to open the Define Import/Export Map dialog box.

9. Ensure that the data fields correctly map to the Project Table fields. Click OK.

10. Click Open on the Import Ma~ping dialog box to import your database into Project.

Importing Data Using ODBC

Importing with ODBC is a two-step process: setting up the ODBC connection and importing the data as you would from other file types, Follow the procedure listed as follows to link to an ODBC data source:

1. In Project 2000, choose File »0 Open to display the Open dialog box.

2. Click the ODBC button. The Select Data Source dialog box.

Figure 19.25

Figure 19.25

3. Select the tab (File Data SOurce or Machine Data Source) that lists the data source you want to open, Machine Data Source, the recommended choice, creates a data source that can be used by any user on this computer.

4. Choose the data source and click OK. The Select Database dialog box.

Figure 19.26

                           Figure 19.26

5. Select the database file you want to import and click OK. After you’ve selected your data source, you can select a database, and then set up your import. Follow these steps to import an entire project or selected data using an existing Import data map, To edit or create a new import data map.

6. The Open From Database dialog box is displayed:

• To import an entire project, select a project from the list on the Entire Projects Tab and click Open.

• To import selected data, select the correct Import Map on the Selective Data Tab and click the Edit button, The Define Import/Export Map dialog box will be displayed. Ensure that the data fields correctly map to the Project Table fields, Click OK.

• Click Open on the Import Mapping dialog box to import your database into Project.

Posted on November 26, 2015 in Importing and Exporting Project Data

Share the Story

Back to Top