i've got a very specific problem to solve.
I'm not interested in "other" ways to solve it, just plain VBA Code which fully or partially helps me solve the Problem.
I want to have a subroutine which Imports Data from Outlook ( a calendar ) into an access Table.
Using the Access 2007 GUI i would just do the following:
"External Data" -> "Import" -> "Outlook Folder" -> Select my Outlook Calendar -> "Finish"
It's very easy because the Name of my destination Table and the source Calendar are just the same.
I've already ceated a form with some functions and an "Import" Button with the code below.
What is currently missing ( and that part should come from you ! ) is the final call, which tells Access to import the Data.
Just take a look at the code below.
Hint: the Code below is working fine, "just" the Import part is missing.
Helpfull links are:
with best regards,
Private Sub Befehl32_Click()
Dim ns As Outlook.NameSpace
Set ns = GetNamespace("MAPI")
Dim Folder As Outlook.MAPIFolder
Set Folder = ns.PickFolder
Set oDataBase = CurrentDb
Set rst = oDataBase.OpenRecordset("Kalender")