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
CalendarGroups	Represents collections of calendars grouped together by users for organizational purposes. Each entry in this table corresponds to a calendar group that can contain one or more individual calendars.
Calendars	Contains individual calendar entries associated with users. Each record represents a calendar that can be used for scheduling events, setting reminders, and tracking availability.
Contacts	Stores contact information for users, including names, email addresses, phone numbers, and other metadata. This table provides access to personal or organizational contact directories.
Events	Stores primary data for calendar events, including subject, location, attendees, and scheduling details. This table supports the management of both one-time and recurring appointments.
ExtendedProperties	Allows access to custom properties added to contact records. Developers use extended properties to store additional metadata beyond the standard contact schema.
Groups	Provides metadata for Microsoft Exchange Groups, including group names, descriptions, membership, and administrative settings. This is useful for auditing group configurations and collaboration patterns across Exchange Online.
MailFolders	Lists all mail folders within user mailboxes, such as Inbox, Sent Items, and custom folders. It enables folder-level message organization and navigation in Exchange.
Messages	Contains metadata and content for email messages sent and received through Exchange. This includes sender, recipient, subject, and body fields for mailbox analytics and compliance checks.
Users	Contains directory information for Exchange users, including user IDs, display names, job titles, and email addresses. It serves as a foundational entity for joining with activity and usage datasets.