{"id":954,"date":"2012-08-14T23:59:00","date_gmt":"2012-08-14T15:59:00","guid":{"rendered":"http:\/\/vm-officeblogs.cloudapp.net\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/"},"modified":"2022-08-16T14:05:33","modified_gmt":"2022-08-16T21:05:33","slug":"plug-into-your-data-connecting-excel-to-an-access-database","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/","title":{"rendered":"Plug into your data: Connecting Excel to an Access database"},"content":{"rendered":"

\"Plug<\/p>\n

Northwind Trading Company, a small wholesale food business, is doing quite well since they moved online.\u00a0Retail merchants across the country buy everything \u00a0from salmon to granola and have it shipped quickly\u00a0to their stores.<\/p>\n

Their customer information is stored in an Access database, and now, the marketing team needs a better way to view it.\u00a0In particular, they are interested in seeing where their customers reside so they can more effectively target their advertising dollars.<\/p>\n

\n\t
\n\t\t
\n\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\"Excel\t\t\t\t<\/div>\n\t\t\t\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Microsoft Excel<\/h2>\n\n\t\t\t\t\t
\n\t\t\t\t\t\t

Turn data into insights.<\/p>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n\n<\/h3>\n

Create a data connection between Excel and Access<\/h3>\n

Luckily, the same features that Excel provides for viewing and organizing information in a spreadsheet, such as filtering<\/span><\/span>, charting<\/a>, and grouping<\/a>, can be used to view and organize information in an Access database. But first you need to create the connection.<\/p>\n

Note: <\/b>We’ll use the sample Northwind Access database to demonstrate how Excel connects to data sources. You can download it here: \u00a0Northwind Web Database<\/a>.<\/span><\/p>\n

1. Go to the Data<\/b> tab in Excel and click the From Access<\/b> button.
\n
\n2.\u00a0On the Select Data Source<\/b> dialog, go to the location where the Access database is stored, select it, and click the Open<\/b> button
\n
\n3.\u00a0On the Select Table <\/b>dialog, choose a table from the database\u00a0to import.
\n
\n4. Accept the default options\u00a0on the\u00a0Import Data<\/b> dialog, and click OK<\/b>.
\n
\nExcel and Access are now connected, and the data from the Northwind CustomersExtended<\/b> table appears in Excel.<\/p>\n

<\/p>\n

Refresh data<\/h3>\n

Now that Northwind can now easily view and analyze the information in its Access database, they want to make sure they are reviewing the latest <\/i>information.There’s a couple ways they can refresh<\/b> the data in their workbook.<\/p>\n

Forced Refresh<\/b><\/p>\n

To force a refresh, click the Refresh All<\/b> button on the Data <\/b>tab. This will instantly import the latest Access data into Excel.<\/b>
\n
\nCustomized Refresh<\/b><\/p>\n

Northwind can customize the refresh behavior for their workbook in the following ways:<\/p>\n

    \n
  • Enable background refresh (this option allows them to continue working in Excel while the refresh operation executes).<\/li>\n
  • Refresh data after a specified time period (e.g. every 30 minutes)<\/li>\n
  • Refresh data when opening a workbook<\/li>\n<\/ul>\n

    1. Click the Connections <\/b>button <\/b>on the Data <\/b>tab, and then click the Properties <\/b>button on the Workbook Connections<\/b> dialog.
    \n
    \n2. On the Connection Properties<\/b> dialog, select the desired Refresh control<\/b> options and click OK<\/b>.
    \n<\/p>\n

    All connected!<\/h3>\n

    Northwind can now make better advertising decisions. Currently, they don’t have a single order from New York for their very popular gnocchi, and so they decide to focus their advertising on the the tratorrias of Little Italy.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Northwind Trading Company is a growing online wholesale food business. Orders from retail merchants are coming in from across the country and are being stored in an Access database. Now the marketing team needs a better way to view the mounds of data. Luckily, the same features that Excel provides for viewing and organizing information in a spreadsheet, can be used to view and organize information in an Access database. But first you need to create the connection.<\/p>\n","protected":false},"author":18,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4035],"product":[4037,4047,4036],"audience":[4102],"tags":[],"coauthors":[4889],"class_list":["post-954","post","type-post","status-publish","format-standard","hentry","content-type-tips-and-guides","product-access","product-excel","product-microsoft-365","audience-small-business"],"yoast_head":"\nPlug into your data: Connecting Excel to an Access database | Microsoft 365 Blog<\/title>\n<meta name=\"description\" content=\"Northwind Trading Company is a growing online wholesale food business. Orders from retail merchants are coming in from across the country and are being stored in an Access database. Now the marketing team needs a better way to view the mounds of data. Luckily, the same features that Excel provides for viewing and organizing information in a spreadsheet, can be used to view and organize information in an Access database. But first you need to create the connection.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Plug into your data: Connecting Excel to an Access database | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"Northwind Trading Company is a growing online wholesale food business. Orders from retail merchants are coming in from across the country and are being stored in an Access database. Now the marketing team needs a better way to view the mounds of data. Luckily, the same features that Excel provides for viewing and organizing information in a spreadsheet, can be used to view and organize information in an Access database. But first you need to create the connection.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-08-14T15:59:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-16T21:05:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3527.SUMMARY_DataConnection_300x166.jpg\" \/>\n<meta name=\"author\" content=\"Courtney Owen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Courtney Owen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/courtney-owen\/\",\"@type\":\"Person\",\"@name\":\"Courtney Owen\"}],\"headline\":\"Plug into your data: Connecting Excel to an Access database\",\"datePublished\":\"2012-08-14T15:59:00+00:00\",\"dateModified\":\"2022-08-16T21:05:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/\"},\"wordCount\":426,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3527.SUMMARY_DataConnection_300x166.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/\",\"name\":\"Plug into your data: Connecting Excel to an Access database | Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3527.SUMMARY_DataConnection_300x166.jpg\",\"datePublished\":\"2012-08-14T15:59:00+00:00\",\"dateModified\":\"2022-08-16T21:05:33+00:00\",\"description\":\"Northwind Trading Company is a growing online wholesale food business. Orders from retail merchants are coming in from across the country and are being stored in an Access database. Now the marketing team needs a better way to view the mounds of data. Luckily, the same features that Excel provides for viewing and organizing information in a spreadsheet, can be used to view and organize information in an Access database. But first you need to create the connection.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3527.SUMMARY_DataConnection_300x166.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3527.SUMMARY_DataConnection_300x166.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Plug into your data: Connecting Excel to an Access database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Plug into your data: Connecting Excel to an Access database | Microsoft 365 Blog","description":"Northwind Trading Company is a growing online wholesale food business. Orders from retail merchants are coming in from across the country and are being stored in an Access database. Now the marketing team needs a better way to view the mounds of data. Luckily, the same features that Excel provides for viewing and organizing information in a spreadsheet, can be used to view and organize information in an Access database. But first you need to create the connection.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/","og_locale":"en_US","og_type":"article","og_title":"Plug into your data: Connecting Excel to an Access database | Microsoft 365 Blog","og_description":"Northwind Trading Company is a growing online wholesale food business. Orders from retail merchants are coming in from across the country and are being stored in an Access database. Now the marketing team needs a better way to view the mounds of data. Luckily, the same features that Excel provides for viewing and organizing information in a spreadsheet, can be used to view and organize information in an Access database. But first you need to create the connection.","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2012-08-14T15:59:00+00:00","article_modified_time":"2022-08-16T21:05:33+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3527.SUMMARY_DataConnection_300x166.jpg"}],"author":"Courtney Owen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Courtney Owen","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/courtney-owen\/","@type":"Person","@name":"Courtney Owen"}],"headline":"Plug into your data: Connecting Excel to an Access database","datePublished":"2012-08-14T15:59:00+00:00","dateModified":"2022-08-16T21:05:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/"},"wordCount":426,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3527.SUMMARY_DataConnection_300x166.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/","name":"Plug into your data: Connecting Excel to an Access database | Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3527.SUMMARY_DataConnection_300x166.jpg","datePublished":"2012-08-14T15:59:00+00:00","dateModified":"2022-08-16T21:05:33+00:00","description":"Northwind Trading Company is a growing online wholesale food business. Orders from retail merchants are coming in from across the country and are being stored in an Access database. Now the marketing team needs a better way to view the mounds of data. Luckily, the same features that Excel provides for viewing and organizing information in a spreadsheet, can be used to view and organize information in an Access database. But first you need to create the connection.","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3527.SUMMARY_DataConnection_300x166.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3527.SUMMARY_DataConnection_300x166.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/14\/plug-into-your-data-connecting-excel-to-an-access-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Plug into your data: Connecting Excel to an Access database"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/954"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=954"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/954\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=954"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=954"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=954"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=954"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}