V
Victoria@DIG
Outlook 2007/Excel 2007/Access 2007
Hello,
I have vacations requested stored in Access 2007. I'd like to export these
to an Outlook 2007 calendar. I've tried the following procedures:
1) Export from Access to Excel in Excel 2003 format.
2) Converted Excel 2003 format to text, tab delimited.
When I tried to import either of these formats I run into the same problem.
When I get to the custom-map-fields dialog of the import wizard, I never get
the option to click OK. I have only three fields: Name, Date, and Type of
Leave. I drag the fields into the following Outlook fields:
Name=Subject
Date=All Day Event
Type of Leave=Location
However only the active buttons are Next, Previous, and Cancel. I tried
renaming the Excel fields to correspond to the Outlook field names so I won't
have to custom map, but nothing gets imported. What may I be doing wrong?
Thanks.
Hello,
I have vacations requested stored in Access 2007. I'd like to export these
to an Outlook 2007 calendar. I've tried the following procedures:
1) Export from Access to Excel in Excel 2003 format.
2) Converted Excel 2003 format to text, tab delimited.
When I tried to import either of these formats I run into the same problem.
When I get to the custom-map-fields dialog of the import wizard, I never get
the option to click OK. I have only three fields: Name, Date, and Type of
Leave. I drag the fields into the following Outlook fields:
Name=Subject
Date=All Day Event
Type of Leave=Location
However only the active buttons are Next, Previous, and Cancel. I tried
renaming the Excel fields to correspond to the Outlook field names so I won't
have to custom map, but nothing gets imported. What may I be doing wrong?
Thanks.