Export from Excel to Project

[Jozie True]

How do I go about exporting data from Excel into Project?
I as told quickly to do it as delimited text? But what is
that?

Sorry if Im confusing

Thanks!
--Jozie

 

[John]

Jozie,
There are a couple ways to get data from Excel to Project. Probably the
easist and most common is to use an import table. An import table
basically maps Excel columns into Project fields. The basic procedure is
as follows (for more details, read the Project help file
1. File/Open
2. At the bottom of the Open WIndow, select the "Files of Type" to
"Microsoft Excel Workbooks".
3. Select the Excel file for import and hit "Open"
4. An Import Mapping window will appear. Hit "New Map".
5. In the Definition window select the types of data you want to import.
6. Select the tab corresponding to the data type and then the Source
Worksheet Name.
7. Start mapping by using the selection boxes in the "To" column to
define which Project field will receive the data from corresponding
fields in the Excel worksheet.

A second method for getting data from Excel to Project is with a VBA
macro. A macro gives maximum flexibility but it does require VBA
knowledge.

Hope this gets you started.
John

 

[Sue Butler]

Project 2003 has an Excel Import Wizard you might want to check out.

Just Open the Excel spreadsheet and the wizard will start up, prompting
you for what you need. If your spreadsheet is is in a reasonable form
you should be able to map it into your MS Project schedule.

Sue
www.kidasa.com