Export Project data to another file format

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.

  1. On the File menu, click Save As.
  2. 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.

  1. In the File name box, type a name for the exported file.
  2. Click Save.
  3. 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.


Applies to:
Project 2003