Ungawenza kanjani umbuzo we-SQL ku-Excel

I-SQL uhlelo lokuhlela oluhle olusetshenziswa lapho lusebenza ngemininingwane (database). Yize ngokusebenza okunemininingwane enemininingwane kwiphakheji ye-Microsoft Office Kukhona uhlelo lokusebenza oluhlukile - Ukufinyelela, kepha uhlelo lwe-Excel lungasebenza ne-database, yenza izicelo ze-SQL. Ake sibheke ukuthi ngezindlela ezahlukahlukene ongazakhela ngazo isicelo esifanayo.

Isifundo: "Smart" amatafula e-Excel

Indlela 2: Kusetshenziswa Amathuluzi Ezengeziwe Ezengeziwe

Kukhona nendlela yokwakha umbuzo we-SQL emthonjeni wedatha okhethiwe usebenzisa amathuluzi owakhelwe ama-Exel.

1. Qalisa uhlelo lwe-Excel. Ngemuva kwalokho, sithuthela kuthebhu "yedatha".



2. Ku "ukuthola idatha yedatha yangaphandle", etholakala ku-Ribbon, chofoza ku- "Kweminye imithombo" isithonjana. Uhlu lwezinketho zokuqhubeka kwesenzo luyavula. Khetha into "kusuka ku-Wizard yokuxhumeka kwedatha".



3. I-Wizard yokuxhumanisa idatha yethulwa. Kuluhlu lwezinhlobo zemithombo yedatha, khetha u- "ODBC DSN". Ngemuva kwalokho, chofoza inkinobho ethi "Next".



4. Iwindows wizard yedatha ivula lapho ufuna ukukhetha khona uhlobo lomthombo. Khetha igama elithi "MS Access Database". Bese uchofoza inkinobho "elandelayo".



5. Iwindi elincane lokuzulazula liyavula, lapho kufanele ushintshele khona kwisikhombisi sedatha kwifomethi ye-MDB noma ye-AccDB bese ukhetha ifayela ledatha oyifunayo. Ukuzula phakathi kwamadiski anengqondo kwenziwa "kuma-disc" akhethekile. Kukhona ushintsho endaweni ephakathi yewindi elibizwa nge- "Catalogs". Ehlane lesokunxele lewindi libonisa amafayela atholakala kwisikhombi esikhona manje uma enokwandiswa kwe-MDB noma i-AccDB. Kukule ndawo okudingeka ukhethe igama lefayela, bese uqhafaza inkinobho ethi "KULUNGILE".



6. Ukulandela lokhu, iwindi lokukhetha itafula selikathunyelwa ku-database ebekiwe. Esifundeni esisenkabeni, khetha igama lethebula oyifunayo (uma kukhona eziningana zazo), bese uqhafaza inkinobho ethi "Next".



7. Ngemuva kwalokho, iwindi lokuxhuma kwedatha yokuxhumanisa liyavuleka. Lokhu kuqukethe imininingwane eyisisekelo mayelana nokuxhumeka esikuhlelayo. Kuleli windi, kwanele ukuchofoza inkinobho ethi "Qede".



8. Ishidi le-Excel livula iwindi lokungenisa idatha. Ingacaciswa ukuthi iyiphi ifomu ofuna idatha elethulwa:
   • Ithebula;
   • Umbiko wetafula elihlanganisiwe;
   • Umdwebo we-Summary.

   Khetha inketho oyifunayo. Okuphansi ngezansi, udinga ukucacisa ukuthi idatha kufanele ibekwe kuphi ngempela: eshidini elisha noma eshidini lamanje. Endabeni yokugcina, amathuba okukhetha izixhumanisi zendawo yokuhlala nawo ayanikezwa. Ngokuzenzakalelayo, imininingwane ibekwe ephepheni lamanje. I-angle engesokunxele yento engenisiwe ibekwa esitokisini A1.

   Ngemuva kokuthi zonke izilungiselelo zokungenisa zichaziwe, chofoza inkinobho ethi "Kulungile".



9. Njengoba sibona, itafula kusuka database lihanjiswa eshidini. Ngemuva kwalokho sithuthela kuthebhu "yedatha" bese sichofoza inkinobho ethi "Ukuxhumana", okubekwe ethepheni kubhulokhi yamathuluzi ngegama elifanayo.



10. Ngemuva kwalokho, iwindi lokuxhuma liqaliwe. Kuyo sibona igama ledatha elixhunywe ngaphambili ngathi. Uma i-database exhunyiwe ngandlela thile, bese ukhetha okufisayo futhi ukugqamisa. Emva kwalokho, chofoza inkinobho ethi "Properties ..." ngakwesokunene sewindows.



11. Iwindi lezindawo zokuxhuma liqala. Sihamba kulo nge- "ncazelo" ithebhu. Ensimini ethi "Umbhalo Wethuthi", etholakala ezansi kwewindows yamanje, bhala umyalo we-SQL ngokuya nge-syntax yalolu limi, esakhuluma kafushane lapho ucubungula indlela 1. Khona inkinobho ethi "KULUNGILE".



12. Emva kwalokho, buyela ngokuzenzakalelayo ekuxhumaneni nencwadi. Ihlala kuphela ukuze uchofoze inkinobho ethi "Vuselela" kuyo. Isikhalazo ku-database enombuzo kwenzeka, ngemuva kwalokho imininingwane ibuyisela imiphumela yokucubungula kwayo emuva eshidini le-Excel, etafuleni ngaphambili elidluliselwe yithi.

Indlela 3: Ukuxhuma kwiseva ye-SQL Server SQL

Ngaphezu kwalokho, ngamathuluzi we-Excel, kukhona ukuxhumana neseva ye-SQL bese uthumela izicelo kukho. Ukwakha umbuzo akuhlukile kwinguqulo yangaphambilini, kodwa okokuqala, udinga ukufaka ukuxhumana uqobo. Ake sibheke ukuthi singakwenza kanjani.

1. Qalisa uhlelo lwe-Excel bese uya kuthebhu yedatha. Emva kwalokho, chofoza inkinobho ethi "Ukusuka Kweminye Imithombo", ebekwe ethepheni "ekutholeni i-Toolbar Yangaphandle" yamathuluzi. Kulokhu, kusuka kuhlu lohlu, khetha inketho "kusuka kwiseva ye-SQL Server".



2. Ivula iwindi lokuxhuma kwiseva yedatha. In the Igama Lerver Igama field, chaza igama leseva owenza ukuxhumana ngayo. Eqenjini "le-akhawunti", udinga ukunquma kahle ukuthi ungaxhuma kanjani: Usebenzisa ubuqiniso beWindows noma ngokufaka igama lomsebenzisi nephasiwedi. Ngikhombisa ukushintshwa ngokwesinqumo esithathiwe. Uma ukhethe inketho yesibili, ngaphezu kwalokho, izinkambu ezifanele kuzodingeka ukuthi zifake igama lomsebenzisi nephasiwedi. Ngemuva kwaloko kuthathwe izilungiselelo, chofoza inkinobho "elandelayo". Ngemuva kokukhipha lesi senzo, ukuxhuma kwiseva ebekiwe. Ezenye izenzo enhlanganweni yesicelo se-database ziyafana nalezo esichazile ngendlela edlule.

Njengoba ukwazi ukubona, ku-Efvela we-SQL, isicelo singahlelelwa njengamathuluzi wohlelo lwakhelwe ngaphakathi kanye nezengezo zangaphandle. Umsebenzisi ngamunye angakhetha inketho ekulula ngayo futhi kufanelekile ukuxazulula umsebenzi othelwe ngokuqondile. Noma, amathuba okufakwa kwe-xltools, ngokuvamile, asathuthuke kakhulu kunamathuluzi ashumekiwe ashumekiwe. Ukuntuleka kwemali okuyinhloko kwama-XLTools ukuthi isikhathi sokusetshenziswa kwamahhala kwezengezo sikhawulelwe kumaviki amabili wekhalenda.