Solved

Sharepoint Calendar and Access

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

743 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

13 Experts available now in Live!

Get 1:1 Help Now