The Excel and SQL Server experts blog

Automatic Data Validation
Kerri Gascoigne - Feb 27, 2024

When users input new values into Excel cells, each entry is instantly validated against the data type of the mapped SQL Server column.
Foreign Key Lookups
milan nikolic - Feb 26, 2024

Lookups of texts for key values in related tables allows end-users to easily work with relational data, while keeping data integrity.

img:is([sizes=auto i],[sizes^="auto," i]){contain-intrinsic-size:3000px 1500px}img.wp-smiley,img.emoji{display:inline !important;border:none !important;box-shadow:none !important;height:1em !important;width:1em !important;margin:0 .07em !important;vertical-align:-.1em !important;background:none !important;padding:0 !important}:root{--wp-block-synced-color:#7a00df;--wp-block-synced-color--rgb:122,0,223;--wp-bound-block-color:var(--wp-block-synced-color);--wp-editor-canvas-background:#ddd;--wp-admin-theme-color:#007cba;--wp-admin-theme-color--rgb:0,124,186;--wp-admin-theme-color-darker-10:#006ba1;--wp-admin-theme-color-darker-10--rgb:0,107,160.5;--wp-admin-theme-color-darker-20:#005a87;--wp-admin-theme-color-darker-20--rgb:0,90,135;--wp-admin-border-width-focus:2px}@media (min-resolution:192dpi){:root{--wp-admin-border-width-focus:1.5px}}.wp-element-button{cursor:pointer}:root .has-very-light-gray-background-color{background-color:#eee}:root .has-very-dark-gray-background-color{background-color:#313131}:root .has-very-light-gray-color{color:#eee}:root .has-very-dark-gray-color{color:#313131}:root .has-vivid-green-cyan-to-vivid-cyan-blue-gradient-background{background:linear-gradient(135deg,#00d084,#0693e3)}:root .has-purple-crush-gradient-background{background:linear-gradient(135deg,#34e2e4,#4721fb 50%,#ab1dfe)}:root .has-hazy-dawn-gradient-background{background:linear-gradient(135deg,#faaca8,#dad0ec)}:root .has-subdued-olive-gradient-background{background:linear-gradient(135deg,#fafae1,#67a671)}:root .has-atomic-cream-gradient-background{background:linear-gradient(135deg,#fdd79a,#004a59)}:root .has-nightshade-gradient-background{background:linear-gradient(135deg,#330968,#31cdcf)}:root .has-midnight-gradient-background{background:linear-gradient(135deg,#020381,#2874fc)}:root{--wp--preset--font-size--normal:16px;--wp--preset--font-size--huge:42px}.has-regular-font-size{font-size:1em}.has-larger-font-size{font-size:2.625em}.has-normal-font-size{font-size:var(--wp--preset--font-size--normal)}.has-huge-font-size{font-size:var(--wp--preset--font-size--huge)}:root .has-text-align-center{text-align:center}:root .has-text-align-left{text-align:left}:root .has-text-align-right{text-align:right}.has-fit-text{white-space:nowrap !important}#end-resizable-editor-section{display:none}.aligncenter{clear:both}.items-justified-left{justify-content:flex-start}.items-justified-center{justify-content:center}.items-justified-right{justify-content:flex-end}.items-justified-space-between{justify-content:space-between}.screen-reader-text{word-wrap:normal !important;border:0;clip-path:inset(50%);height:1px;margin:-1px;overflow:hidden;padding:0;position:absolute;width:1px}.screen-reader-text:focus{background-color:#ddd;clip-path:none;color:#444;display:block;font-size:1em;height:auto;left:5px;line-height:normal;padding:15px 23px 14px;text-decoration:none;top:5px;width:auto;z-index:100000}html :where(.has-border-color){border-style:solid}html :where([style*=border-color]){border-style:solid}html :where([style*=border-top-color]){border-top-style:solid}html :where([style*=border-right-color]){border-right-style:solid}html :where([style*=border-bottom-color]){border-bottom-style:solid}html :where([style*=border-left-color]){border-left-style:solid}html :where([style*=border-width]){border-style:solid}html :where([style*=border-top-width]){border-top-style:solid}html :where([style*=border-right-width]){border-right-style:solid}html :where([style*=border-bottom-width]){border-bottom-style:solid}html :where([style*=border-left-width]){border-left-style:solid}html :where(img[class*=wp-image-]){height:auto;max-width:100%}:where(figure){margin:0 0 1em}html :where(.is-position-sticky){--wp-admin--admin-bar--position-offset:var(--wp-admin--admin-bar--height,0px)}@media screen and (max-width:600px){html :where(.is-position-sticky){--wp-admin--admin-bar--position-offset:0px}}.wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none}:root{--wp-internal-comment:"Placeholder for wp_hoist_late_printed_styles() to replace with the block styles printed at wp_footer."}:root{--wp-internal-comment:"Placeholder for wp_hoist_late_printed_styles() to replace with the global-styles printed at wp_footer."}@media (min-width: 1025px){body .uag-hide-desktop.uagb-google-map__wrap,body .uag-hide-desktop{display:none !important}}@media (min-width: 768px) and (max-width: 1024px){body .uag-hide-tab.uagb-google-map__wrap,body .uag-hide-tab{display:none !important}}@media (max-width: 767px){body .uag-hide-mob.uagb-google-map__wrap,body .uag-hide-mob{display:none !important}}.align-icons-center{display:flex;justify-content:center;gap:13px}.thankyou-block .wp-block-group__inner-container{display:flex;flex-direction:column;gap:16px;padding:56px 0}.thankyou-block .wp-block-group__inner-container h1{line-height:52px}.link-to-visit a{justify-content:center;display:flex;gap:5px;align-items:center;color:#14944d !important;text-align:center;font-size:18px;font-style:normal;font-weight:700;line-height:30px}.thk-content{max-width:560px;margin:auto}.faq-v2 .hidden{display:none}@media screen and (max-width: 568px){.thankyou-block .wp-block-group__inner-container h1{font-size:30px !important;line-height:35px}}@media screen and (min-width: 782px){.forminator-pagination-start .forminator-row:nth-child(2){margin-bottom:-20px}.forminator-pagination{width:70%;margin:auto;z-index:9999999;position:relative}.forminator-field .first-step .content{margin-top:-80px !important}.forminator-pagination-start .forminator-row:nth-child(2) #email-1{margin-bottom:5px !important}.forminator-pagination-start .forminator-row:nth-child(3){margin-bottom:0px !important}.forminator-pagination-footer{bottom:30px;right:0px;width:100%;position:absolute}.forminator-ui.forminator-custom-form-10151.forminator-design--default .forminator-step-label{top:3px;left:8px}.forminator-ui.forminator-custom-form-10151.forminator-design--default .forminator-button-submit{position:absolute !important;left:280px;z-index:9999999999;font-size:18px !important;min-width:150px !important;display:flex !important;justify-content:center !important;padding:16px 24px !important;border-radius:10px !important;margin-top:-50px !important}.forminator-checkbox-label{font-size:15px}}.forminator-row #checkbox-1{margin-top:-20px !important}.forminator-pagination-footer:has(button.forminator-button-submit) .forminator-button-back,.forminator-ui.forminator-custom-form-10151.forminator-design--default .forminator-step-4{display:none !important}.forminator-pagination .forminator-pagination--content .forminator-row:nth-child(2){margin-bottom:0 !important}@media screen and (max-width: 782px){.forminator-ui.forminator-custom-form-10151.forminator-design--default .forminator-checkbox-label{font-size:12px !important}.forminator-row #checkbox-1{margin-top:8px !important}.forminator-pagination-steps{display:flex !important;align-items:center}.forminator-break{width:100% !important;height:1px !important}.forminator-pagination-footer{position:relative;display:flex !important;justify-content:space-between;align-items:center}.forminator-pagination-footer *{width:40% !important;margin:0}.forminator-pagination-footer .forminator-button-submit{width:100% !important}.forminator-ui.forminator-custom-form-10151.forminator-design--default .forminator-step-label{top:3px !important;left:8px !important}}.forminator-break:first-child,.forminator-break:nth-last-child(1),.forminator-break:nth-child(9),.forminator-step-4,#forminator-module-10151 .forminator-step-4{display:none !important}.forminator-select.forminator-select-dropdown-container--open .forminator-select-dropdown .select2-results .select2-results__options{max-height:420px !important}.select2-results__options li{border-bottom:1px solid #b3bbcd}

The Excel and SQL Server experts blog

Automatic Data Validation

Foreign Key Lookups

Love Excel? Need to update SQL Server data?