Importing labour from CSV / XLS into Project 2007

W

walterboy83

Hi,

We are looking at an easier method of updating actuals within MS Project.
We currently manually key-in labour days into their respective tasks within
Project.

Can anyone give any direction on uploading labour figures into Project 2007
using a CSV file or something similar? (eg XLS)

If not, can anyone recommend a good place to start digging?

Cheers!
 
J

Jim Aksel

It seems like a Macro using VBA is in order.
The key will be to match appropriate labor costs to specific work packages
in MS Project. Typically labor costs are collected at a higher level than
the detailed line items of MS Project schedules.

So, you will need a way to cross reference your Excel Spreadsheet data to
the Work Package level in MS Project.
--
If this post was helpful, please consider rating it.

Jim

Check out my new blog for more information:
http://www.msprojectblog.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Project 2007 CSV Import corruption 3
.csv import and merge issues with Project 2007 7
Convert a csv to xls prior to import 2
Import MS-Access 2007 5
Importing tasks from EXCEL deleting dependancies 9
Import - Corrupting Predecessors in Project 2007 3
Disconnection of TFS from Project 2007 - Work Item ids get blank in Project 2007 File 1

Top