Importing calendar events from Microsoft Access.

[Scott Niederkorn]

When using Office 2000, I was able to import date and
time from a single field in Access to both the 'Start
Date' and 'Start Time' in Outlook (using 'Map Custom
Fields'). The date/time field in Access would be split
into two separate values for mapping to Outlook fields.

Now I have upgraded to Office XP with Outlook 2002 and
cannot map the same field from my Access database to both
the 'Start Date' & 'Start Time' fields of Outlook. In
the 'Map Custom Fields' dialog, it only lists a single
date/time field in the values list and will not allow me
to map this field to both the 'Start Date' & 'Start Time'
fields.

Is there a quick fix for this or will I have to separate
the date and time into two fields in the Access database??

 

[Sue Mosher [MVP-Outlook]]

Since Outlook uses a single date/time field, I'd try mapping to Start Date.