{"id":3690,"date":"2024-12-03T03:31:52","date_gmt":"2024-12-03T03:31:52","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-ket-noi-toi-sql-sever-de-lay-du-lieu-vao-excel\/"},"modified":"2024-12-03T03:31:52","modified_gmt":"2024-12-03T03:31:52","slug":"huong-dan-cach-ket-noi-toi-sql-sever-de-lay-du-lieu-vao-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-ket-noi-toi-sql-sever-de-lay-du-lieu-vao-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch k\u1ebft n\u1ed1i t\u1edbi SQL Sever \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u v\u00e0o Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> <\/strong>s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n <a href=\"http:\/\/blog.ezworkapp.com\/cach-ket-noi-toi-sql-sever-de-lay-du-lieu-vao-excel.html\"><strong>c\u00e1ch k\u1ebft n\u1ed1i\u00a0 SQL<\/strong><\/a> Sever v\u00e0 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb SQL Sever v\u00e0o Excel m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674e7ba791b56\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-ket-noi-toi-sql-sever-de-lay-du-lieu-vao-excel.html#Cach_thuc_hien_ket_noi_SQL\" title=\"C\u00e1ch th\u1ef1c hi\u1ec7n k\u1ebft n\u1ed1i SQL\">C\u00e1ch th\u1ef1c hi\u1ec7n k\u1ebft n\u1ed1i SQL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-ket-noi-toi-sql-sever-de-lay-du-lieu-vao-excel.html#Tam_ket\" title=\"T\u1ea1m k\u1ebft\">T\u1ea1m k\u1ebft<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_thuc_hien_ket_noi_SQL\"><\/span>C\u00e1ch th\u1ef1c hi\u1ec7n <strong>k\u1ebft n\u1ed1i SQL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n k\u1ebft n\u1ed1i\u00a0 SQL Sever \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u v\u00e0o Excel ta l\u00e0m c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p>T\u1ea1i Tab Data tr\u00ean thanh Ribbon c\u1ee7a Excel b\u1ea1n v\u00e0o t\u00ecm t\u1edbi m\u1ee5c <strong>From Other Sourcers.\u00a0<\/strong>T\u1ea1i \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn From SQL Sever ho\u1eb7c From Microsoft Query \u0111\u1ec3 k\u1ebft n\u1ed1i v\u1edbi SQL \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u.<\/p>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch \u0111\u1ea7u \u0111\u00f3 l\u00e0 l\u1ef1a ch\u1ecdn From SQL Sever.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31320\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-11.png\" alt=\"cach-ket-noi-toi-sql-1\" width=\"390\" height=\"350\" title=\"1-11\"><\/p>\n<p><span style=\"font-size: inherit\">Sau khi From SQL Sever b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c 1 h\u1ed9p tho\u1ea1i nh\u01b0 sau.<\/span><\/p>\n<ol>\n<li><strong>Save Name:<\/strong> B\u1ea1n \u0111i\u1ec1n t\u00ean Sever m\u00e0 b\u1ea1n mu\u1ed1n k\u1ebft n\u1ed1i t\u1edbi<\/li>\n<li><strong>Log on credentials:<\/strong> Ho\u1eb7c l\u00e0 b\u1ea1n ch\u1ecdn m\u1eb7c \u0111\u1ecbnh k\u1ebft n\u1ed1i v\u1edbi TK Windown, ho\u1eb7c l\u00e0 b\u1ea1n ch\u1ecdn k\u1ebft n\u1ed1i v\u1edbi User Name v\u00e0 m\u1eadt kh\u1ea9u.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31321\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-4.png\" alt=\"cach-ket-noi-toi-sql-2\" width=\"350\" height=\"248\" title=\"2-4\"><\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-287.gif\" title=\"ex101_92019-nho-287\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-123.gif\" title=\"vba101_92019-nho-123\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-287.gif\" title=\"ex101_92019-nho-287\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u1ede \u0111\u00e2y m\u00ecnh ch\u1ecdn k\u1ebft n\u1ed1i m\u1eb7c \u0111\u1ecbnh, \u1ea5n Next \u0111\u1ec3 sang b\u01b0\u1edbc ti\u1ebfp theo, l\u00fac n\u00e0y h\u1ed9p tho\u1ea1i Data Connection Wizard xu\u1ea5t hi\u1ec7n.<\/p>\n<p>B\u1ea1n ch\u1ecdn database mu\u1ed1n k\u1ebft n\u1ed1i t\u1edbi, danh s\u00e1ch c\u00e1c Table trong database \u0111\u00f3 s\u1ebd hi\u1ec7n l\u00ean, b\u1ea1n ch\u1ecdn Table m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u t\u1eeb \u0111\u00f3, sau \u0111\u00f3 \u1ea5n Next \u0111\u1ec3 sang b\u01b0\u1edbc ti\u1ebfp theo<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31333\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-2.png\" alt=\"cach-ket-noi-toi-sql-3\" width=\"403\" height=\"286\" title=\"7-2\"><\/p>\n<p>n\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n thay \u0111\u1ed5i g\u00ec th\u00eam th\u00ec b\u1ea1n \u1ea5n Finish \u0111\u1ec3 t\u1edbi v\u1edbi h\u1ed9p tho\u1ea1i Import Data<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31322\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-4.png\" alt=\"cach-ket-noi-toi-sql-4\" width=\"392\" height=\"333\" title=\"3-4\"><\/p>\n<p>T\u1edbi b\u01b0\u1edbc n\u00e0y, h\u1ed9p tho\u1ea1i Import Data xu\u1ea5t hi\u1ec7n b\u1ea1n l\u1ef1a ch\u1ecdn k\u1ebft n\u1ed1i theo \u00fd m\u00ecnh.<\/p>\n<ul>\n<li>Khi ch\u1ecdn Table th\u00ec d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u1ea3i d\u1eef li\u1ec7u v\u00e0o Excel d\u01b0\u1edbi d\u1ea1ng Table (L\u01b0u \u00fd: N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n l\u1edbn h\u01a1n s\u1ed1 d\u00f2ng t\u1ed1i \u0111a trong Excel th\u00ec s\u1ebd c\u00f3 th\u00f4ng b\u00e1o l\u1ed7i)<\/li>\n<li>Khi ch\u1ecdn PivotTable Report th\u00ec d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c Load v\u00e0o Excel \u1edf d\u1ea1ng PivotTable \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n Pivot lu\u00f4n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31323 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-4.png\" alt=\"cach-ket-noi-toi-sql-5\" width=\"307\" height=\"270\" title=\"4-4\"><\/p>\n<ul>\n<li>Khi ch\u1ecdn PivotChart th\u00ec d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c t\u1ea3i \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n v\u1ebd c\u00e1c Chart<\/li>\n<li>Khi ch\u1ecdn Only Create Connection th\u00ec d\u1eef li\u1ec7u trong Editor \u0111\u01b0\u1ee3c t\u1ea3i v\u00e0o Excel \u1edf d\u1ea1ng ch\u1ec9 l\u00e0 k\u1ebft n\u1ed1i t\u1edbi Data \u0111\u00f3, v\u1edbi d\u1eef li\u1ec7u n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c nh\u01b0 PivotTable, PivotChart,\u2026.tu\u1ef3 \u00fd khi c\u1ea7n.<\/li>\n<\/ul>\n<p>M\u00ecnh ch\u1ecdn Load Data n\u00e0y v\u00e0o \u00f4 A1 trong Sheet1, b\u1ea1n s\u1ebd nh\u00ecn th\u1ea5y k\u1ebft qu\u1ea3 l\u00fac n\u00e0y nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31324 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-2.png\" alt=\"cach-ket-noi-toi-sql-6\" width=\"590\" height=\"322\" title=\"5-2\"><\/p>\n<p>M\u00ecnh \u0111\u00e3 v\u00e0o SQL Sever \u0111\u1ec3 ki\u1ec3m tra v\u1edbi c\u00e2u l\u1ec7nh <strong>SELECT * FROM dbo.VD<\/strong> v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 ho\u00e0n to\u00e0n ch\u00ednh x\u00e1c.<\/p>\n<p>Qu\u00e1 tr\u00ecnh k\u1ebft n\u1ed1i SQL th\u00e0nh c\u00f4ng<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31325\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-3.png\" alt=\"cach-ket-noi-toi-sql-7\" width=\"743\" height=\"318\" title=\"6-3\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tam_ket\"><\/span>T\u1ea1m k\u1ebft<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u1ec9 v\u1edbi c\u00e1c b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n tr\u00ean l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 <strong>k\u1ebft n\u1ed1i SQL<\/strong> Sever \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u v\u00e0o Excel m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c r\u1ed3i. Gi\u1edd \u0111\u00e2y, m\u1ed7i l\u1ea7n d\u1eef li\u1ec7u ngu\u1ed3n trong SQL Sever thay \u0111\u1ed5i th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n Refresh l\u1ea1i trong Excel th\u00ec ngay l\u1eadp t\u1ee9c nh\u1eefng g\u00ec thay \u0111\u1ed5i c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt cho b\u1ea1n.<\/p>\n<p>Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n<p>Tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong> ngay d\u01b0\u1edbi \u0111\u00e2y<\/p>\n<hr>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/vo-hieu-hoa-chuc-nang-tu-phat-hien-kieu-du-lieu-trong-power-query-editor.html\"><em><strong>V\u00f4 hi\u1ec7u ho\u00e1 ch\u1ee9c n\u0103ng t\u1ef1 ph\u00e1t hi\u1ec7n ki\u1ec3u d\u1eef li\u1ec7u trong power query editor<\/strong><\/em><\/a><\/p>\n<p><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-cai-dat-power-query-trong-excel-2010-2013-2016.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u00e0i \u0111\u1eb7t power query trong excel 2010, 2013, 2016<\/a><\/strong><\/em><\/p>\n<p><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/chuan-hoa-kieu-du-lieu-kho-voi-cong-cu-power-query-trong-excel.html\">Chu\u1ea9n ho\u00e1 ki\u1ec3u d\u1eef li\u1ec7u \u201ckh\u00f3 \u0111\u1ee1\u201d v\u1edbi c\u00f4ng c\u1ee5 power query trong excel<\/a><\/strong><\/em><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-287.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3691,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3690","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3690","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=3690"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3690\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3691"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}