You can export (exporting: Transferring data from Project to another program, such as Excel. When you export data, you choose or create a map that specifies the relationship between the fields in Project and the columns in the ouptut file.) information from Microsoft Office Project 2003 to another format, such as Microsoft Excel (as a workbook or PivotTable), Microsoft Project Database (MPD), Microsoft Access Database (MDB), Open Database Connectivity (ODBC) (ODBC: A vendor-neutral interface, based on the SQL Access Group specifications announced by Microsoft. A developer can use ODBC to gain access to data in a heterogeneous environment of relational and nonrelational databases.)-compliant database formats that Project supports (Microsoft SQL Server and Oracle Server), Extensible Markup Language (XML) (XML: Extensible Markup Language [XML] is a format for delivering rich, structured data from an application in a standard, consistent way. XML describes the content of a document, whereas HTML tags describe how the document looks.), Hypertext Markup Language (HTML) (HTML: An acronym for Hypertext Markup Language, which is a formatting convention for presenting text and graphics on the World Wide Web.), and comma-separated values (CSV) (CSV: The comma-separated values [CSV] file format is an ASCII, record-based text format in which each field is separated by a list-separator character, usually a comma or semicolon. Each task or resource record ends with a carriage return and linefeed.) or text-only format.
- On the File menu, click Save As.
- In the Save as type box, select the file format you want to export data to.
To export project data to a SQL Server or Oracle Server format, click ODBC, and then continue with step 5.
- In the File name box, type a name for the exported file.
- Click Save.
- Follow the instructions in the Export Wizard to export the data you want into the proper fields of the destination (destination: Where moved, copied, imported, or exported information is inserted; also a view, table, document, or another program. In OLE, the document or program where a linked object resides; also, the document that a hyperlink leads to.) file.
- You can only export an entire project to XML format. Project maps the data automatically, without the Export Wizard. Also, to minimize the file size, fields that contain null values are not included in the exported XML file.
- You can include timephased (timephased: Task, resource, or assignment information that is distributed over time. You can review timephased information in any available time period in the fields on the right side of the Task Usage and Resource Usage views.) data when you save the entire project to a database format such as SQL, Oracle, or Access. On the Tools menu, click Options, click the Save tab, and then click the file format you want in the Save Microsoft Office Project files as box. Under Database save options, select the Expand timephased data in the database check box. To set this as the default for future projects, click Set as Default. You cannot include timephased data when you export selected project information.