Software

Ask something
Discussion Locked

Importing Outlook tasks into Access

0 helpful
3 replies

by Member 33509877 2 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am setting up support procedures, using Outlook (mail, tasks and calendar) to receive and track requests. How can I import the Tasks data into Access for analysis without rekeying any info?

3 replies

by donq

Each data container in Access has a Field Name where programmers stuff incoming data. You will need to identify each Outlook object that will be imported by name and then write an Access Procedure that Updates and/or Appends (depending on your need) Outlook data into a pre-defined Access Table(s) wher data types are designed to always accept what is stored in Outlook.

The process is not difficult for an experiences VB of VBA programmer that understands database normalization and has a little coding experience using OLE objects.

Good Luck!

by Member 33509877

Although I am not an experienced programmer, at least this tells me it can be done! My investigation starts now...
Thanks.

This discussion is closed to new replies.