Cara Menyisipkan Query SQL di Microsoft Excel

PDF download Unduh PDF
PDF download Unduh PDF

Artikel ini akan memandu pengguna untuk menyisipkan query SQL pada Excel 2010 dan membuat koneksi dinamis.

Langkah

PDF download Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/5c\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-1-Version-3.jpg\/v4-460px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5c\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-1-Version-3.jpg\/v4-728px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/88\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-2-Version-3.jpg\/v4-460px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/88\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-2-Version-3.jpg\/v4-728px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c3\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-3-Version-3.jpg\/v4-460px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c3\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-3-Version-3.jpg\/v4-728px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Pilih "ODBC DSN" pada opsi yang tersedia, kemudian klik “Next” .
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bc\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-4-Version-3.jpg\/v4-460px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bc\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-4-Version-3.jpg\/v4-728px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Pilih basis data yang sesuai, kemudian klik “Next” .
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c1\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-5-Version-3.jpg\/v4-460px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-5-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c1\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-5-Version-3.jpg\/v4-728px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d3\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-6-Version-3.jpg\/v4-460px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d3\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-6-Version-3.jpg\/v4-728px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Pilihlah basis data yang sesuai.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/17\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-7-Version-3.jpg\/v4-460px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-7-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/17\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-7-Version-3.jpg\/v4-728px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Jendela tersebut akan menampilkan nama berkas sesuai data yang telah dipilih pada layar sebelumnya.
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/ec\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-8-Version-3.jpg\/v4-460px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-8-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ec\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-8-Version-3.jpg\/v4-728px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Di jendela ini, pilihlah data yang sesuai, lalu klik "OK".
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f2\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-9-Version-3.jpg\/v4-460px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-9-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f2\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-9-Version-3.jpg\/v4-728px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-9-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/41\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-10-Version-3.jpg\/v4-460px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-10-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/41\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-10-Version-3.jpg\/v4-728px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Pada jendela selanjutnya, klik Properties .
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/78\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-11-Version-3.jpg\/v4-460px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-11-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/78\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-11-Version-3.jpg\/v4-728px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-11-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c3\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-12-Version-2.jpg\/v4-460px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-12-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c3\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-12-Version-2.jpg\/v4-728px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Excel akan menampilkan data hasil query .
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e6\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-13-Version-2.jpg\/v4-460px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-13-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e6\/Embed-a-SQL-Query-in-Microsoft-Excel-Step-13-Version-2.jpg\/v4-728px-Embed-a-SQL-Query-in-Microsoft-Excel-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Iklan

wikiHow Terkait

Cara
Mengubah Koma Menjadi Titik pada Microsoft Excel
Cara
Menghapus Halaman Kosong di Word
Cara
Membuat Teks Rata Tengah di Microsoft Word
Cara
Menambah Tanda Centang ke Dokumen Word
Cara
Membuka Proteksi Lembar Kerja Excel
Cara
Membuat Paragraf Menjorok di Dalam Word
Cara
Menambahkan Nomor Halaman di Microsoft Word
Cara
Mengubah Dokumen Hasil Scan Ke File Microsoft Word
Cara
Menampilkan Baris Tersembunyi di Excel
Cara
Membuat Simbol X Garis Atas di Microsoft Word
Cara Mudah Membuat Tanda Panah di Word pada Komputer Windows atau Mac
Cara
Menghilangkan Status 'Read Only' pada Dokumen MS Word
Cara
Menampilkan Kembali Kolom Tersembunyi di Excel
Cara
Menyisipkan Kotak Centang di Word
Iklan

Tentang wikiHow ini

Bahasa lain
Halaman ini telah diakses sebanyak 15.304 kali.

Apakah artikel ini membantu Anda?

Iklan