+ Post New Thread
Results 1 to 10 of 10
Virtual Learning Platforms Thread, Import Calendar Into Sharepoint in Technical; Hi, Currently our school calender is created in a spreadsheet that get's printed off. As we will be using Sharepoint ...
  1. #1

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    5,037
    Thank Post
    160
    Thanked 908 Times in 712 Posts
    Blog Entries
    3
    Rep Power
    270

    Import Calendar Into Sharepoint

    Hi,

    Currently our school calender is created in a spreadsheet that get's printed off.

    As we will be using Sharepoint as of september, the Deputy would like to build the calendar on sharepoint instead of having a printed version.

    To add every event into the calendar is going to be a pretty big job, and its a pretty big process to add an event.

    So

    Is there anyway we can import events into the calendar from csv format or something along those lines?

    Many Thanks

    James.

  2. #2
    trolley01's Avatar
    Join Date
    Mar 2009
    Location
    Wisbech
    Posts
    71
    Thank Post
    3
    Thanked 18 Times in 14 Posts
    Rep Power
    14
    Untested answer here:

    Once you have created your calendar in Sharepoint, you can open the calendar from Sharepoint in Access. From there you could then import the CSV.

  3. #3

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    5,037
    Thank Post
    160
    Thanked 908 Times in 712 Posts
    Blog Entries
    3
    Rep Power
    270
    Thanks for the reply,

    I say what i am hoping for is that i give her a spreadsheet with headers, she fills it in and then i can simply import it into sharepoint

    I might be dreaming

  4. #4
    trolley01's Avatar
    Join Date
    Mar 2009
    Location
    Wisbech
    Posts
    71
    Thank Post
    3
    Thanked 18 Times in 14 Posts
    Rep Power
    14
    I've just tried it.

    I created an Excel spreadsheet with headings on it relating to the fields in the Calendar. Then opened the calendar through Sharepoint, go to Actions and then Open with Access. In Access I then Imported the data to the table. Refreshed the calendar, and the data appeared.

  5. #5

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    5,037
    Thank Post
    160
    Thanked 908 Times in 712 Posts
    Blog Entries
    3
    Rep Power
    270
    Awesome... Thank you i'll give that ago now.

    James.

    Edit: Hmm, I dont have Open with Access in Actions i only have Export to Spreadsheet, RSS Feeds
    Last edited by EduTech; 26th March 2009 at 01:00 PM.

  6. #6
    trolley01's Avatar
    Join Date
    Mar 2009
    Location
    Wisbech
    Posts
    71
    Thank Post
    3
    Thanked 18 Times in 14 Posts
    Rep Power
    14
    No problem.

    Have found it is a bit picky over data formats. If you can it would be worth setting up some validation on the spreadsheet now before you give it to someone else - should save you a headache later!

  7. #7

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    5,037
    Thank Post
    160
    Thanked 908 Times in 712 Posts
    Blog Entries
    3
    Rep Power
    270
    Any one else got any thoughts?

    I never had "Open With Access" in the "Actions" Menu.

    Cheers

    James.

  8. #8
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,121
    Thank Post
    537
    Thanked 150 Times in 136 Posts
    Blog Entries
    78
    Rep Power
    79
    I just had a quick look at mine - and this works for me to (although since we also use Office 2007 - the calendar can be edited in Outlook)...

    I've got the Connect to Access option...

  9. #9

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    5,037
    Thank Post
    160
    Thanked 908 Times in 712 Posts
    Blog Entries
    3
    Rep Power
    270
    Quote Originally Posted by stuartwilkie View Post
    I just had a quick look at mine - and this works for me to (although since we also use Office 2007 - the calendar can be edited in Outlook)...

    I've got the Connect to Access option...
    Ah i see, so what haven't to configured then... hmm... going to have a little look i think as this cant be right

    Cheers for clarifying that stuart.

    James.

  10. #10

    Join Date
    Feb 2011
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by trolley01 View Post
    I've just tried it.

    I created an Excel spreadsheet with headings on it relating to the fields in the Calendar. Then opened the calendar through Sharepoint, go to Actions and then Open with Access. In Access I then Imported the data to the table. Refreshed the calendar, and the data appeared.


    I am trying to do a similar task only I am having issues importing Excel into Access so I can refresh the data. Can you maybe give some more instructions?

    Mickie

SHARE:
+ Post New Thread

Similar Threads

  1. Sharepoint profile import stuck on Enumerating
    By HMCTech in forum Virtual Learning Platforms
    Replies: 14
    Last Post: 9th December 2009, 03:30 AM
  2. Moodle Calendar - import from MS Outlook
    By IT_Man_Dan in forum Virtual Learning Platforms
    Replies: 2
    Last Post: 12th November 2009, 09:08 AM
  3. Sharepoint Calendar
    By wesleyw in forum Virtual Learning Platforms
    Replies: 7
    Last Post: 27th March 2009, 12:55 PM
  4. Sharepoint colour calendar problem
    By imiddleton25 in forum Virtual Learning Platforms
    Replies: 5
    Last Post: 12th September 2008, 11:13 PM
  5. Sharepoint colour calendar
    By imiddleton25 in forum Virtual Learning Platforms
    Replies: 2
    Last Post: 11th June 2008, 04:12 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •