I-Microsoft Query Wizard ku-Excel

Lesi sibonelo sizokufundisa indlela yokungenisa idatha kusuka kusizindalwazi se-Microsoft Access usebenzisa i-Microsoft Query Wizard. Ngokusebenzisa Umbuzo we-Microsoft, ungakhetha amakholomu owafunayo bese uwangenisa ku-Excel kuphela.

1. Kuthebhu ethuthukisiwe Idatha (idatha) chofoza Eminye Imithombo (Kusuka kweminye imithombo) bese ukhetha Kusuka Umbuzo weMicrosoft (Kusuka ku-Microsoft Query). Ibhokisi lengxoxo lizovela Khetha Umthombo Wedatha (Khetha umthombo wedatha).
2. Khetha I-MS Access Database* bese uqoka ibhokisi eliseduze kwenketho Sebenzisa Iwizadi Yombuzo ukuze udale/uhlele imibuzo (Sebenzisa Isilekeleli Sombuzo).
3. Cindezela OK.
4. Khetha i-database bese uchofoza OK.Le database iqukethe amathebula amaningana. Ungakhetha ithebula namakholomu ozowafaka embuzweni.
5. Gqamisa itafula amakhasimende bese uchofoza inkinobho enophawu ">".
6. Cindezela Olandelayo (Okwengeziwe).
7. Ukuze ungenise kuphela idathasethi eshiwo, yihlunge. Ukuze wenze lokhu, khetha imizwa Ohlwini Ikholomu ezohlungwa (Amakholomu azokhethwa). Ngakwesokudla, kuhlu lokuqala lokudonsela phansi, khetha kufana (elingana), futhi kwesibili igama lomuzi - I-New York.
8. Cindezela Olandelayo (Okwengeziwe).

Ungakwazi ukuhlunga idatha uma ufuna, kodwa ngeke sikwenze lokho.

9. Cindezela Olandelayo (Okwengeziwe).
10. Cindezela Qeda (Kwenziwe) ukuze uthumele idatha ku-Microsoft Excel.
11. Khetha uhlobo lwesibonisi solwazi lapho ufuna ukubeka khona idatha bese uchofoza OK.

Umphumela:

Qaphela: Lapho i-database yokufinyelela ishintsha, ungachofoza ukuvuselela (Qala kabusha) ukuze ulande izinguquko ku-Excel.