In Microsoft Excel eine SQL Abfrage einbetten

PDF herunterladen
PDF herunterladen

Dieser Artikel hilft Benutzern, in Excel 2010 eine SQL-Abfrage einzubetten und eine dynamische Anbindung in Excel zu erstellen.

Vorgehensweise

PDF herunterladen
  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>"}
    Wähle aus den verfügbaren Optionen "ODBC DSN" und klicke auf "Weiter".
  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>"}
    Hier wird eine Liste mit den in deiner Organisation verfügbaren Datenbanken angezeigt. Wähle die entsprechende Datenbank und klicke auf "Weiter".
  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>"}
    Triff also die entsprechende Auswahl.
  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>"}
    Das Fenster zieht den Dateinamen entsprechend deiner Auswahlen in den vorherigen Bildschirmen.
  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>"}
    Hier kannst du nach Bedarf Optionen auswählen und auf "OK" klicken.
  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>"}
    Klicke im folgenden Fenster auf "Eigenschaften".
  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 zeigt das Ergebnis entsprechend der Abfrage an.
  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>"}
    Werbeanzeige

Verwandte wikiHows

Eine Dropdown Liste in Excel erstellen
In Excel Spalten einklappen
Ein Diagramm in Excel erstellen
In Excel führende oder anhängende Nullen entfernen
In Excel Kleinbuchstaben in Großbuchstaben umwandeln
Versteckte Zeilen in Excel wieder anzeigen
In Excel die relative Standardabweichung berechnen
Einen Kalender in Microsoft Excel erstellen
In MS Excel automatisch nummerieren
Zwei Excel Dateien vergleichen
In Excel aus einem Komma einen Punkt machen
In Excel Text verkürzen
In Excel den Standardfehler des Mittelwerts berechnen
In Excel Tabellen verlinken
Werbeanzeige

Über dieses wikiHow

In anderen Sprachen
Diese Seite wurde bisher 52.641 mal abgerufen.

War dieser Artikel hilfreich?

Werbeanzeige