Tables
The add-in models the data in Microsoft Exchange as a list of tables in a relational database that can be queried using standard SQL statements.
CData Excel Add-In for Microsoft Exchange Tables
| Name | Description |
| Calendar | Create, update, delete, and query Calendar items. |
| Calendar_OptionalAttendees | The optional attendees for a particular event. An ItemId must be specified when querying this view. |
| Calendar_RequiredAttendees | The required attendees for a particular event. An ItemId must be specified when querying this view. |
| Contacts | Create, update, delete, and query Contacts items. |
| DeletedItems | Create, update, delete, and query Deleted Items. |
| Drafts | Create, update, delete, and query Drafts items. |
| Folders | Create, update, delete, and query subfolders for a given folder. |
| Inbox | Create, update, delete, and query Inbox items. |
| JunkEmail | Create, update, delete, and query Junk Email items. |
| Outbox | Create, update, delete, and query Outbox items. |
| SentItems | Create, update, delete, and query Sent Items. |
| Tasks | Create, update, delete, and query Tasks items. |