Solved

Sharepoint Calendar and Access

Posted on 2014-10-09
4
352 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
  • 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

932 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now