Import Access 2013 events to Outlook Calendar

D Willett
SilverLounger
Posts: 1728
Joined: 25 Jan 2010, 08:34
Location: Stoke on Trent - Staffordshire - England

Import Access 2013 events to Outlook Calendar

Post by D Willett »

Hi
Before upgrading to Outlook 2013 I was able to import events from an Access database using the import wizard from the old calendar ( Outlook 2007 ).
This feature doesn't seem to be present any more or there is a different process. Does anyone know how to replicate how the old import used to work in 2013.

Kind Regards
Cheers ...

Dave.

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Import Access 2013 events to Outlook Calendar

Post by Rudi »

Hi,

In Outlook 2013 one only has the option to import a pst file of a csv file. So you will need to open your Access database and export the table containing your events data to a csv file format.
Once exported as a csv file you can then go back to Outlook and
From the File Tab choose Open and Export, then Import/Export
From the resulting dialog choose Import from another program or file.
Click Next and select Comma Separated Values,
Click Next and browse for the file you exported from Access
Click Next and select Calendar
Continue through the wizard till Finish.

Note: AFAIK, importing into a calendar needs specific Field Names in your source data.
You need at least "Subject," "Start Date" and "Location" as heading so the wizard knows where to import the data onto your calendar...
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

D Willett
SilverLounger
Posts: 1728
Joined: 25 Jan 2010, 08:34
Location: Stoke on Trent - Staffordshire - England

Re: Import Access 2013 events to Outlook Calendar

Post by D Willett »

Hi Rudi
I see it is doable but not so automated as before.
I have a virtual xp setup on my Windows 7 so probably better to import from that.
Thanks for looking into this.

Kind Regards
Cheers ...

Dave.

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Import Access 2013 events to Outlook Calendar

Post by Rudi »

Whether it was a dumbed down modification or a specific reason behind the removal of those additional import options.... :shrug:
In any event, it does make it more of an effort to import Access or Excel data with that extra process to get it as csv. :crazy:
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Import Access 2013 events to Outlook Calendar

Post by HansV »

Microsoft never bothered to update the import mechanism to support the new .accdb database format, it only worked for .mdb. I suspect they won't put any effort in desktop Access-related features any more.
Best wishes,
Hans