importing data

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Importing data

resolvedResolved · Low Priority · Version 2003

Sarah has attended:
Project Intro Intermediate course

Importing data

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

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

RE: importing data

Hi Simon

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

Thanks

Sarah

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 tip:

Formatting Bar Text

To display notes or resource initials on the Gantt chart bars, choose Format, Bar Styles and the Text tab. Select the position you want to show the text i.e. Top or Inside etc, then choose the field name you are looking for from the drop down arrow. Type the first letter of the name to get quickly to the top of the letter range. Click OK.

View all MS Project hints and tips


Server loaded in 0.08 secs.