Saving and Opening with Different File Formats

A file format is an arrangement of data in a file that specifies the file type and defines the file in a way that enables any application that can open the file to open it correctly. When you create and save a regular project file, it’s saved as an MPP file. The file name’s .mpp extension indicates that this is indeed a regular project file.

However, you can save project files in other file formats. You can also open files with other file formats in Microsoft Project. Table 29-1 details the file formats supported by Microsoft Project for saving, opening, or both.

Table 29-1. Supported File Formats

File format

Extension

Open or Save

Notes

Microsoft Project Plan

.mpp

Open

Save

Opens or saves the file as a Microsoft Project Plan file, which is the default file type for projects being opened or saved.

Microsoft Project 2000-2003 Plan

.mpp

Open

Save

Opens or saves the file as a Microsoft Project Plan file using the file format used by Microsoft Project 2000, 2002, and 2003.

Microsoft Project 98 Plan

.mpp

Open

Opens a project file that was saved using the file format used by Project 98.

Microsoft Project template

.mpt

Open

Save

Opens a template file. You can change and save those changes to the template file. Saves the file as a Microsoft Project template file. The template can then be used as a basis for new projects.

Microsoft Project workspace

.mpw

Open

Save

Saves all open project files as a Microsoft Project workspace file through the File, Save Workspace command. When you open an MPW file, all associated projects are opened in a single step.

Microsoft Project Exchange

.mpx

Open

Opens a file created in a version of Microsoft Project earlier than Microsoft Project 98. This is a record-based ASCII text file format that Project 2007 can read, allowing earlier Microsoft Project files to be converted to Project 2007 files.

Microsoft Project database

.mpd

Open

Opens a legacy Microsoft Project database.

Microsoft Access database

.mdb

Open

Opens a Microsoft Access database file in Microsoft Project.

Open Database Connectivity

 

Open

Opens a database file created in ODBC-compliant Microsoft SQL Server databases. To open an ODBC file, click the ODBC button in the Open dialog box and follow the instructions in the Select Data Source dialog box.

Microsoft Excel workbook

.xls

Open

Save

Opens, through the import process, an Excel workbook in Microsoft Project.

Saves certain fields as a Microsoft Excel data so the file can then be opened in Microsoft Excel.

Microsoft Excel PivotTable

.xls

Save

Saves selected field data to a Microsoft Office Excel PivotTable, which can then be opened in Microsoft Office Excel. A PivotTable is a table that combines and compares large amounts of data, and in which you can rotate columns and rows to modify the source data to create different views.

Text (Tab delimited)

.txt

Open

Save

Opens information in a plain text file that uses tabs to separate fields of data.

Saves fields from a single Microsoft Project table in the same way.

This is ideal for using the project information in a third-party application or on another operating system.

Text (comma delimited)

.csv

Open

Save

Opens a text file that uses commas to separate fields of data.

Saves Microsoft Project data as a text file using commas to separate the data.

This is ideal for using the project information in a third-party application or on another operating system.

Extensible Markup Language

.xml

Open

Save

You can open an XML file in Microsoft Project. For Microsoft Project to understand and open it, an XML file must conform to the Microsoft Project XML schema.

You can also save a project file as XML data. When Microsoft Project saves data as XML, the structure is determined by the Microsoft Project XML schema.

Opening a file from a different file format in Microsoft Project can be referred to as importing the file. Likewise, saving a project file with a different file format can be referred to as exporting the file. There’s often more to the import and export process than simply opening or saving the file. Often you need to create an import/export map.

Note

For more information about creating an import or export map, see the section titled Importing and Exporting Information in Chapter 16.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.225.95.245