Aug 23, 2016
If you have a list of appointments in Excel and you want to append them to your SharePoint calendar follow these steps:
- In Your SharePoint calendar click on the Calendar tab and select Open with Access
- SharePoint creates an .accdb file and lets you choose where you want to save it. This file will be linked to your SharePoint calendar. Click on OK.
- It opens the file in
Access. Click on the EXTERNAL DATA tab and select Excel. - Specify the Excel source file and then tick Append a copy of the records to the table and select Calendar from the drop down.
- Click on OK.
- If you wish, you can save this procedure in Access by checking the box Save import steps. Later on if you add more appointments to the Excel sheet, all you have to do is open the Access file you saved in step 2 above, and then go to EXTERNAL DATA tab and click on Saved Imports.
You now have the information inside your Access table. But remember, this table is linked to your SharePoint calendar. So if you switch back to SharePoint and refresh your calendar you should have the appointments there. You can now close your Access application.
Note: your Excel table should have the same column headings as your calendar.
New Horizons offers training in all available versions of Microsoft Excel, for more information please click here.
Cyrus Mohseni.
How do your Excel skills stack up?
Test NowNext up:
- Master the art of masking in Photoshop
- 10 steps to becoming a terrific facilitator
- Managing performance – The good and the bad
- PowerShell Basics Series – PowerShell Pipelining
- Win the next productivity award with Microsoft Project
- Designer’s guide on the Golden Ratio – Why it matters
- Happy Anniversary
- Beginner in design? Here is what you need to know
- How to use Excel range names efficiently in calculations
- It is not about 'Traditional' OR 'Social' selling … It is about 'Traditional' AND 'Social' selling
Previously
- Master the art of masking in Photoshop
- Learn to lead and inspire people with these TED Talks
- The Windows Key
- The best leaders develop their followers
- The Deming Cycle
- Enter Power BI
- Working with Styles – Part 3
- 10 steps to working better in SharePoint
- Four ways you can create a better workplace
- Handling difficult conversations at work