I have got a years worth of data (a full school years calendar events) on an Excel spreadsheet which needs to be uploaded to sharepoint in order to create a calendar list allowing everyone in the school to view all school events for the next year but then
I want to use the 'actions > export to outlook' setting so that certain users can also have this data displayed within their outlook calendar.
I initially used the import a spreadsheet option only to find it will import the data and create the calendar view but this isn't a true calendar and doesn't provide me with the export to outlook feature within the settings option.
After reading many threads I have tried to export to Access and then import the data this was as a csv files, the data does import but Access then asks me where I want to save the access database within my sharepoint site but when I click save it tells
me that it isn't able to save to that location.
I have seen lots of ways to import data and then use the calendar view but after this I also want to export to outlook and an actual calendar is under the tracking heading on sharepoint as opposed to a list and it doesn't let you import spreadsheet in this
way.
Could anybody help please?
Thanks in advance.