98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » Importing data
Importing data
Resolved · 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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Formatting Bar TextTo 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. |