Solved

Sharepoint Calendar and Access

Posted on 2014-10-09
4
399 Views
Last Modified: 2014-11-04
Hello,

I have an excel file with [DueDates] and [TaskDescription].
I know Access can upload data to the Lotus Notes calendar with VBA code
Is it possible to upload calendar entries to Sharepoint?  

thank you
0
Comment
Question by:pdvsa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 9

Accepted Solution

by:
macarrillo1 earned 500 total points
ID: 40405664
The short answer is yes.

A  SharePoint Calendar is really a list. So you would import data from Access/Excel to a SharePoint List.

Here is a general explanation of how to do it.

For a more specific description you need to provide the version of MS Access or Excel and the version of SharePoint.
0
 

Author Comment

by:pdvsa
ID: 40421594
Hi, sorry I had forgotten about this thread.  

Do you happen to know if upon an export to sharepoint, you can delete the list first and then import?  I will be exporting the list frequently and want to avoid duplicates.  I know Outlook has this feature.  I have never used sharepoint.
0
 
LVL 9

Expert Comment

by:macarrillo1
ID: 40421978
With the PowerShell command there is an option to overwrite. So you can overwrite your list with your imported list.
0
 

Author Comment

by:pdvsa
ID: 40422251
thank you very much...
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question