{"id":41541,"date":"2012-11-28T00:00:00","date_gmt":"2012-11-28T06:00:00","guid":{"rendered":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/"},"modified":"2012-11-28T00:00:00","modified_gmt":"2012-11-28T06:00:00","slug":"weekly-etip-excel-spreadsheet-to-access-database","status":"publish","type":"post","link":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/","title":{"rendered":"Weekly eTip &#8211; Excel spreadsheet to Access Database"},"content":{"rendered":"<div class=\"panel body-content\"><div class=\"panel__container\"><p><B>I have data in an Excel spreadsheet that I would like to use in an Access Database. What are the steps?<\/B><\/p>\n<p>Importing or linking data from Excel to Access works well if the Excel data is in rows and columns without any subtotal rows, formulas or blank rows or blank columns within the worksheet or range. Column headings should not be wrapped or contain special characters and must be unique names. Then, to cleanly import data:<br \/>\n<UL><LI>Create a blank database in Access (or an existing database you wish to place it) and select the External Data tab > Excel (from the Import group).<br \/>\n<LI>Find the Excel file and select &#8220;Import the source data into a new table in the current database&#8221; or &#8220;link to the data source by creating a linked table.&#8221;<br \/>\n<LI>Follow the screens until the process is finished. <\/UL><\/p>\n<p><B>Automatic updates<\/B><\/p>\n<p>If you have cells that contain formulas, they will import as values. When importing, the Access table is completely separate from your Excel file. Any updates made in Excel or Access after the import are not updated in both applications. However, if you &#8220;Link&#8221; the data, you can only update from the Excel file, but the data is automatically updated in Access so that it can be used for filters, queries and reports.<\/p>\n<p>Keep in mind just because you have Excel data that imports or links well into Access does not mean that your file is set up ideally to work in Access. In addition, Microsoft Access requires a considerable investment in time to learn how to use it, compared to Excel. But Access works well if you have a lot of data in separate but related tables to analyze. <\/p>\n<p><B>Learn more<\/B><\/p>\n<p>Learn more about database design concepts at ITS&#8217; mini-session on Thursday from 2 to 3 p.m. in the ITS training room, 8011 Wittson Hall. Additional Access training is available in December. <a href=\"http:\/\/www.unmc.edu\/its\/training.htm\" target=\"_blanK\" rel=\"noopener\">See the ITS class schedule and online registration<\/a>.<\/p>\n<div style=\"display: none;\"><a rel=\"nofollow\" href=\"\/secure-location.php\" title=\"TtEUoyEktpj U\">TtEUoyEktpj U<\/a><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>I have data in an Excel spreadsheet that I would like to use in an Access Database. What are the steps?<\/p>\n","protected":false},"author":94,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-41541","post","type-post","status-publish","format-standard","hentry","category-uncategorized","topic-inside-unmc","department-unmc-today-todays-headlines"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Weekly eTip - Excel spreadsheet to Access Database<\/title>\n<meta name=\"description\" content=\"I have data in an Excel spreadsheet that I would like to use in an Access Database. What are the steps?\" \/>\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.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Weekly eTip - Excel spreadsheet to Access Database\" \/>\n<meta property=\"og:description\" content=\"I have data in an Excel spreadsheet that I would like to use in an Access Database. What are the steps?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Newsroom\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/unmcedu\" \/>\n<meta property=\"article:published_time\" content=\"2012-11-28T06:00:00+00:00\" \/>\n<meta name=\"author\" content=\"Chuck Brown\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@unmc\" \/>\n<meta name=\"twitter:site\" content=\"@unmc\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chuck Brown\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/2012\\\/11\\\/28\\\/weekly-etip-excel-spreadsheet-to-access-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/2012\\\/11\\\/28\\\/weekly-etip-excel-spreadsheet-to-access-database\\\/\"},\"author\":{\"name\":\"Chuck Brown\",\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/#\\\/schema\\\/person\\\/f99efde0b91c6c20a256357d501c35d3\"},\"headline\":\"Weekly eTip &#8211; Excel spreadsheet to Access Database\",\"datePublished\":\"2012-11-28T06:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/2012\\\/11\\\/28\\\/weekly-etip-excel-spreadsheet-to-access-database\\\/\"},\"wordCount\":328,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/2012\\\/11\\\/28\\\/weekly-etip-excel-spreadsheet-to-access-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/2012\\\/11\\\/28\\\/weekly-etip-excel-spreadsheet-to-access-database\\\/\",\"url\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/2012\\\/11\\\/28\\\/weekly-etip-excel-spreadsheet-to-access-database\\\/\",\"name\":\"Weekly eTip - Excel spreadsheet to Access Database\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/#website\"},\"datePublished\":\"2012-11-28T06:00:00+00:00\",\"description\":\"I have data in an Excel spreadsheet that I would like to use in an Access Database. What are the steps?\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/2012\\\/11\\\/28\\\/weekly-etip-excel-spreadsheet-to-access-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/2012\\\/11\\\/28\\\/weekly-etip-excel-spreadsheet-to-access-database\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/2012\\\/11\\\/28\\\/weekly-etip-excel-spreadsheet-to-access-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Weekly eTip &#8211; Excel spreadsheet to Access Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/#website\",\"url\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/\",\"name\":\"Newsroom\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/#organization\",\"name\":\"University of Nebraska Medical Center\",\"url\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/overview-1.png\",\"contentUrl\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/overview-1.png\",\"width\":500,\"height\":153,\"caption\":\"University of Nebraska Medical Center\"},\"image\":{\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/unmcedu\",\"https:\\\/\\\/x.com\\\/unmc\",\"https:\\\/\\\/instagram.com\\\/iamunmc\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/UNMCEDU\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/#\\\/schema\\\/person\\\/f99efde0b91c6c20a256357d501c35d3\",\"name\":\"Chuck Brown\",\"url\":\"https:\\\/\\\/www.unmc.edu\\\/newsroom\\\/author\\\/f4b9ec30ad9f68f89b29639786cb62ef\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Weekly eTip - Excel spreadsheet to Access Database","description":"I have data in an Excel spreadsheet that I would like to use in an Access Database. What are the steps?","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.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/","og_locale":"en_US","og_type":"article","og_title":"Weekly eTip - Excel spreadsheet to Access Database","og_description":"I have data in an Excel spreadsheet that I would like to use in an Access Database. What are the steps?","og_url":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/","og_site_name":"Newsroom","article_publisher":"https:\/\/www.facebook.com\/unmcedu","article_published_time":"2012-11-28T06:00:00+00:00","author":"Chuck Brown","twitter_card":"summary_large_image","twitter_creator":"@unmc","twitter_site":"@unmc","twitter_misc":{"Written by":"Chuck Brown","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/#article","isPartOf":{"@id":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/"},"author":{"name":"Chuck Brown","@id":"https:\/\/www.unmc.edu\/newsroom\/#\/schema\/person\/f99efde0b91c6c20a256357d501c35d3"},"headline":"Weekly eTip &#8211; Excel spreadsheet to Access Database","datePublished":"2012-11-28T06:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/"},"wordCount":328,"commentCount":0,"publisher":{"@id":"https:\/\/www.unmc.edu\/newsroom\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/","url":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/","name":"Weekly eTip - Excel spreadsheet to Access Database","isPartOf":{"@id":"https:\/\/www.unmc.edu\/newsroom\/#website"},"datePublished":"2012-11-28T06:00:00+00:00","description":"I have data in an Excel spreadsheet that I would like to use in an Access Database. What are the steps?","breadcrumb":{"@id":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/28\/weekly-etip-excel-spreadsheet-to-access-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.unmc.edu\/newsroom\/"},{"@type":"ListItem","position":2,"name":"Weekly eTip &#8211; Excel spreadsheet to Access Database"}]},{"@type":"WebSite","@id":"https:\/\/www.unmc.edu\/newsroom\/#website","url":"https:\/\/www.unmc.edu\/newsroom\/","name":"Newsroom","description":"","publisher":{"@id":"https:\/\/www.unmc.edu\/newsroom\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.unmc.edu\/newsroom\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.unmc.edu\/newsroom\/#organization","name":"University of Nebraska Medical Center","url":"https:\/\/www.unmc.edu\/newsroom\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.unmc.edu\/newsroom\/#\/schema\/logo\/image\/","url":"https:\/\/www.unmc.edu\/newsroom\/wp-content\/uploads\/2022\/08\/overview-1.png","contentUrl":"https:\/\/www.unmc.edu\/newsroom\/wp-content\/uploads\/2022\/08\/overview-1.png","width":500,"height":153,"caption":"University of Nebraska Medical Center"},"image":{"@id":"https:\/\/www.unmc.edu\/newsroom\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/unmcedu","https:\/\/x.com\/unmc","https:\/\/instagram.com\/iamunmc","https:\/\/www.youtube.com\/user\/UNMCEDU"]},{"@type":"Person","@id":"https:\/\/www.unmc.edu\/newsroom\/#\/schema\/person\/f99efde0b91c6c20a256357d501c35d3","name":"Chuck Brown","url":"https:\/\/www.unmc.edu\/newsroom\/author\/f4b9ec30ad9f68f89b29639786cb62ef\/"}]}},"_links":{"self":[{"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/posts\/41541","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/users\/94"}],"replies":[{"embeddable":true,"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/comments?post=41541"}],"version-history":[{"count":0,"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/posts\/41541\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/media?parent=41541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/categories?post=41541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/tags?post=41541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}