View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Anyway to transfer data from an excel spreadsheet to Project?

Dianne

I did the unthinkable.....

Opened MS Project and Help "import"

Found this...........

Import data from another file format

You can import information into any entered field from another product's file
format, such as Microsoft Office Excel 2003, Microsoft Office Access 2003,
Open Database Connectivity (ODBC)-compliant database formats that supports
(Microsoft SQL Server and Oracle Server), Extensible Markup Language (XML)
format, and a comma-separated values (CSV) or tab-delimited text format.


Gord Dibben Excel MVP

On Tue, 6 Dec 2005 14:05:02 -0800, "dcws2003"
wrote:

I've started planning next year and would like to print out the entire year
in calendar form. Unfortunately my group does all planning and file exchanges
in an Excel spreadsheet, so that how I laid out most of Q1 2006...Is there a
way to download the data in my project Name field and my Date field to
Project? Or must I reenter everything into Project manually?

Thanks in Advance,
Dianne