The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Project Training and help » Importing data

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Importing data

Resolved · Low Priority · Version 2003

ReplyTue 12 May 2009, 16:32Delegate Sarah said...

Importing data

How do I imput data from multiple excel spreadsheets in to ms project?

For upcoming training course dates see: Pricing & availability

ReplyWed 13 May 2009, 11:45Trainer Simon said...

RE: importing data

Hi Sarah,

Thank you for your question.

As far as I know, you can only import data from one spreadsheet at a time.

However, you can create some VBA code to import data from multiple sources.

I hope this answers your question.

Regards

Simon

ReplyFri 15 May 2009, 12:04Delegate Sarah said...

RE: importing data

Hi Simon

Thanks for that. Please can remind me how to import data from an excel spreadsheet?

Thanks

Sarah

ReplyMon 18 May 2009, 16:20Trainer Simon said...

RE: importing data

Hi Sarah,

Thank you for your response.

The procedure is as follows:

1. Open the Project file.
2. Go to File and Open.
3. Change the File Type to Excel Workbooks.
4. Select the file by double clicking.
5. This will start the Import Wizard.
6. Choose a new map or use an existing one.
7. Tell project which file you want the data imported to.
8. Decide on what type of data you need ie. Task or Resources or both.
9. Map the fields you need from Excel with the fields you want them imported into in Project.
10. Complete the wizard.

I hope this answers your question.

Regards

Simon

Tue 26 May 2009: Automatically marked as resolved.

MS Project articles

· Communicating Your Project Without Microsoft Project.
· MS Project Milestones Need Not Be Millstones
· The Evolution of the Microsoft Project 2007 User
· Finding Your Way With The Project Map
· Looking After Your Workforce With Microsoft Project

Please browse our web site to find out more about
microsoft professional project server training and other Microsoft training courses.

Ms project tip:

Set default task type - Project 2010

a. In Project, click on the File tab
b. Select Options from left hand side
c. Click on Schedule to set the scheduling options
d. Set the Default Task type box to your chosen option
i. Generally if you plan/estimate your projects using durations you should use fixed duration, and untick the box New tasks are effort driven, if you plan/estimate with person hours use fixed work, or for plans estimated with the proportion of resources time use fixed units, and untick the box New tasks are effort driven)
e. Click OK to apply your changes

View all MS Project hints and tips

Is there a way of performing random selections on an excel spreadsheet? For example if we have a list of jobs from which we need to select 10% for QC, is there an easy way of doing this?