
Sep 12, 2014
In my previous blog post, I explained the settings you would need to change in Microsoft Project to ensure you’re able to import a Microsoft Access database. In this article, I’ll go through the steps required to import your Access database file into Project. This is a great feature if the user responsible for the development of a Microsoft Project plan wants to delegate work to other team members who do not have Project installed or do not know how to use the application. These files can contain resource information, task information or assignment information. To start the process of importing, follow the steps listed below:- Open a New project file.
- Click the File –> Open options.
- In the Look in: field, select the folder where your Microsoft Access file is located.
- For Files of Type:, select Microsoft Access Databases.
- Double-click the file you want to use. The Import Wizard dialogue box will display the below.
- Click Next to continue.
- Select New Map. Maps are a set of instructions telling Microsoft Project how to import the selected file.
- Click Next to continue. The window below should appear.
This window gives you 3 options:
- As a new project – select this options if you want to import access data into a new project file.
- Append the data to the active project – select this options if you want to import access data into an existing project file.
- Merge the data into the active project – select this options if you want to import access data into an existing project file and to merge it with the existing project information.
- Click Next to continue. The window below is displayed.You have to select the types of data you want to import.
- Click Next to continue. The window below is displayed. Here you have to select the source database table that holds the resources information. You also have to map the fields.
- Click Next to continue.
- Save the map if you want to use it again
- Click Finish.
How do your Excel skills stack up?
Test NowNext up:
- Use conditional formatting to create a Gantt Chart
- Certificate Error, go back to start, do not collect $200
- Telling people that their feet smell and other delightful office conversations
- Action buttons and hyperlinks in PowerPoint
- All about abstract classes in C#
- All about autofill in Microsoft Excel
- Asynchronous programming in C#
- Eliminating hurdles for effective customer service
- Dynamic charts in Microsoft Excel
- A closer look at Cisco UCS
Previously
- Connecting people in SharePoint 2013
- Why you need to know about the Show/Hide button ¶
- Cloud computing with Microsoft Azure
- I Know!
- Passwords and alternative credentials in PowerShell
- Create an advanced filter in Excel
- The Silver Rule of Negotiation
- Voice Resiliency Features of Lync Server 2013
- Heading styles in Microsoft Word
- Setting up your first Office 365 Tenant account