Microsoft® Office Project 2007 Inside Out

Importing and Exporting with Excel

Suppose you want to move larger quantities of information between Microsoft Project and Excel, or you don’t like having to jockey columns around to make sure data transfers to the right place. For these situations, you can import or export information in either direction—from Microsoft Project to Excel or from Excel to Microsoft Project. Importing information means bringing information from a foreign file format into the current application (for example, from the Excel XLSX file format to Microsoft Project, which uses the MPP file format). When you export information, you’re saving information in the current application in a different file format so that it can be opened by another application. In both cases, ...