O'Reilly logo

Microsoft Project 2007: The Missing Manual by Bonnie Biafore

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing and Exporting Data

Arranging columns in the right order, selecting data, and copying it to the right place is tedious and error-prone. A more dependable way to get data from one place to another is importing or exporting, depending on which direction the data is headed. In this book, importing means pulling data into Project from another program, for instance, importing data from an Excel spreadsheet or an Access database. Exporting pushes data out of your Project file to another file format like Excel or XML. Unlike linking and embedding, importing and exporting convert data from one file format to another, so the data is the same as what you enter directly in the destination program.

The great thing about importing and exporting is the control you have over the data you transfer and where it goes. Because you map fields in one program to fields in the other, you can make sure the right types of data go where you want.

Project provides wizards for importing and exporting data to and from your Project files. The wizards (as the box on Importing Data into Project explains) start automatically when you open a file in another format or save to another format. For example, if you open an Excel spreadsheet in Project, then the Import Wizard starts up. Saving a Project file as a text file launches the Export Wizard.

Note

The Project Guide includes a link to launch the Import Wizard. In the Project Guide's Tasks pane, click "List the tasks in the project". In the List Tasks pane, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required