Importing Excel into Outlook Public Folder

Firstly let me state this all highly hypothetical as I don't have access to Public Folders etc at present so can't check but...

Using OL/XL VBA... it sounds to me as though you have r/x access to the public folders already so in theory you should be able to create a namespace to the Public Folder in question as opposed to your default Personal Folders. Assuming you do you should be able to clear all items from the existing calendar and then iterate the .csv and repopulate the calendar with new items.

I have a few posts here re: automatiing OL tasks as do others -- if you run a search you may find something of use as a starting point. You will need to decide as to which app (XL/OL) you wish to use as base for code ... sounds to me as though in this instance coding in OL is the way forward given you're not really using XL for anything (I'm assuming you're creating the .csv from your 3rd party app directly?).

Someone else may post up with more info for you soon.

In the meantime I will see if I can put something together quickly as a proof of concept.

I have a similar problem, but the suggestion would not work. A number of calendars exist in the Public Folder arena. These are used for forward planning events. The majority of these events, eg Appeal Court cases, are imported in via manipulation of the appeal courts roster of upcoming cases. However once the case is underway, various editors can input updates as to when the case has been adjourned to. The calendars thus consist of a mixture of imported information and updated input. To overwrite the information would result in loss of the directly input information. Any suggestions, or is it back to the drawing board?