Import data into Project from another file format

You can import (importing: Transferring data into Project from a source program, such as Excel. When you import data, you choose a map that defines how the data in the source program should be mapped to information in Project.) information into Microsoft Office Project 2003 into any entered field (entered field: A field in which you may type or edit information. This is in contrast with a calculated field, in which Project calculates and enters information.) from another product's file format (file format: The particular way in which information is stored in a file. Different programs use different file formats and file name extensions to indicate the format.), such as Microsoft Office Excel 2003, Microsoft Office Access 2003, 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 (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.) format, and a 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 tab-delimited text format.

  1. Click Open Button image.

If you are connected to Microsoft Office Project Server 2003, click Open from File.

  1. In the Files of type box, click the file type you want to import data from.

To import data from a SQL Server or Oracle Server format, click ODBC to connect to your data source, and then continue with step 5.

  1. In the Look in box, locate the folder that contains the file you want to import, and then select the file in the file list.

If needed, you can search for the file.

  1. Click Open.
  2. Follow the instructions in the Import Wizard to import the data you want into the proper Microsoft Office Project 2003 fields.


Applies to:
Project 2003