Outlook calendar link to Access - data missing

Copper Contributor

Hi Guys,

very new to this forum... 

 

I have a calendar in Outlook which shows all the data I need (calendar from an ical file link).   

In access I have then used 'Get External Data'  to link to an Outlook file,  and it does create a link too a new table as expected.  So far so good.

However on closer inspection of the data in Access the field in Outlook shown as 'Location' in the calendar does not appear anywhere in an Access field?

In this instance the location data is crucial to what I am doing.

How can i make the  Calendar location field visible in Access??

Can i link the ical direct to Access without going through Outlook?

Help pls?

Mike

0 Replies