Category Archive for: Importing and Exporting Project Data

Jazzing Up Headers Footers and Legends with Graphics

You can insert a graphic file as a static picture in Headers, Footers and Legends. This is  a similar process to copying and pasting a picture into these areas. In this example, we will use the Gantt Chart view, but this process works in most views. 1. Open Project and go to a Gantt Chart view.…

Read More →

Creating a New View for Pasted Data

Sometimes, it’s easier to create a new view that includes the fields you want to paste, along with the Project key field you ‘need to display to know how to sort the Excel file. In this example, we will add a new column to the Resource Sheet view for email address arid sort the view by Resource Name…

Read More →

Linking Data to a Project

Copy and Link Data from Another Application If you want to copy data into a Project file and maintain a dynamic link to the source file, follow these steps: 1. Open the source application. Select the data to be embedded in Project and copy it. 2. Open your project file. Choose Edit >- Paste Special to…

Read More →

Understanding Converted Objects

Switch to the destination document and place the insertion point where you want to paste the selection. To convert the data, simply paste it into the document. Of course, copying data into Project is more complex than-simply converting values from an Excel spreadsheet int.o a Word table, although. the conversion of fields takes place automatically, But, when copying into…

Read More →

Exporting Data to Databases

Why Might You Export Data to a Database? • To send project data for analysis on heavy-duty mainframe or mini-computer based databases • To query Project 2000 data using SQl and OLAP tools Databases use these file formats: MPD, MDB,various ODBC formats. Save an Entire Project as a Project Database (MPD) or Access Database (MOB) This…

Read More →

Exporting to Specific Application

In this section, you’ll find step-by-step instructions and examples for exporting Project 2000 files to specific. applications. As with importing, the export routines for each application vary only because of the different file formats used by applications. Whether you’re exporting Excel, Access, Project, ODBC databases r or text files, you use the same tools. Exporting to Project 98 You…

Read More →

Exporting Data from Project

The knowledge amassed in a typical project can benefit the entire organization. But the best way to share this information is not always a Gantt Chart. You can create reports, publications and presentations. You can send selected project data to a spreadsheet for some serious financial analyses. You can al~o, using Microsoft Project Central, send information to Outlook Task…

Read More →

Moving a Microsoft Outlook Task List to Microsoft Project

Project and Outlook support two common file formats: Access and Excel, We’ll export data from Outlook to Excel, create a custom data map, and import the data from/Excel into Project, To play along, you need to have Outlook 98 or 2000; and Excel 95, 97, or 2000 installed on your computer, This is a multi-step process, but well…

Read More →

Importing Data from Databases

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…

Read More →

Importing Text Files

Text files are even more common than Excel workbooks, The Windows Notepad application creates text files, but any word processor can export a text file. On Web pages, the submit forms that are used to gather information about visitors, customers, or user logins often save the results in text files. Before you begin importing a text file, open…

Read More →

Back to Top