I-Excel Front End ku-SQL Server

Umsebenzisi ojwayelekile ukhululekile ukusebenza ku- Microsoft Excel . Kungani ungahlinzeki abasebenzisi bakho ngethuluzi abesazi futhi bangeze kulo uxhumano kwimvelo yakho ye- SQL Server . Inzuzo yale ndlela i-spreadsheet yabo ye-Excel ihlale isesikhathini samanje kwedatha yedatha yokugcina. Kuyinto evamile kubasebenzisi ukufaka idatha ku-Excel kodwa ngokuvamile kuyisithombe esifingqiwe sedatha ngesikhathi esithile. Lesi sihloko sizokubonisa ukuthi kulula kangakanani ukumisa isipredishithi se-Excel ngokuxhuma kwi-SQL ongayinikezela kubasebenzisi bakho.

Kulesi sibonelo, sizosebenzisa idatha yesampula ye-Adventure Works iMicrosoft ehamba nge-SQL Server 2008.

Kunzima: Isilinganiso

Isikhathi Esidingekayo: Amaminithi angu-10

Lapha & # 39; s Kanjani

1. Uzodinga izingcezu ezimbalwa zolwazi ukusetha uxhumano lwe-Excel kuya ku-SQL Server.
   1. • Igama leSQL Server - Esikhathini sethu, iSQL Server i-MTP \ SQLEXPRESS.
2. Igama lesisekelo - Isibonelo sethu, sisebenzisa idatha ye-AdventureWorks.
3. Ithebula noma Buka - Silandela ukubuka kwe-Sales.vIndividualCustomer.
4. Vula i-Excel bese udala ibhuku lokusebenzela elisha.
5. Chofoza kuthebhu yedatha. Thola indawo ethi "Thola Idatha yangaphandle" bese uchofoze ku- "Kusuka Kweminye Imithombo" bese ukhetha "Kusuka ku-SQL Server". Lokhu kuvulwa "I-Data Connection Wizard".
6. Gcwalisa Igama leSeva. Kulesi sibonelo, igama leseva "MTP \ SQLEXPRESS". Setha Izimvume Zokungena ngemvume "Sebenzisa i-Windows Authentication". Enye indlela ingasetshenziswa uma umqondisi wedatha yakho enikeze igama lomsebenzisi nephasiwedi yomsebenzisi wakho. Chofoza Okulandelayo. Lokhu kuphakamisa "i-Data Connection Wizard".
7. Khetha i-database ("AdventureWorks" kusibonelo sethu) kusukela "Khetha i-database equkethe idatha oyifunayo" ibhokisi lehla phansi. Qiniseka ukuthi "Xhuma etafuleni elithile" lihlolwe. Thola indawo yokubuka ("Sales.vUkuphelaCustomer" kusibonelo sethu) ohlwini bese ukhetha. Chofoza u-Finish oletha ibhokisi lokungenisa le-Import Data.

1. Hlola ibhokisi lokuhlola lethebula bese ukhetha ukuthi ufuna ukubeka idatha (ishidi lokusebenza elikhona noma ishidi lamakhasi elisha). Chofoza OK okwenza uhlu lwe-Excel bese ungenisa yonke ithebula kufasitredishithi sakho.
2. Londoloza isipredishithi sakho futhi uthumele kumsebenzisi. Into enhle mayelana nale nqubo yukuthi umsebenzisi wakho uthola idatha yamanje uma kunesidingo. Ngenkathi idatha igcinwa kuspredishithi, kukhona uxhumano kwiDatha ye-SQL. Noma kunini lapho ufuna ukuvuselela ispredishithi, chofoza ngakwesokudla kwenye indawo etafuleni bese uchofoze ku "Ithebula" bese "Uvuselele". Yilokho kuphela.

Amathiphu

1. Kubaluleke kakhulu ukuthi uqinisekise ukuthi umsebenzisi usethe ngokufanele ku-SQL Server. Yilokho okubangela izinkinga ezimweni eziningi usebenzisa le nqubo.
2. Hlola inombolo yamarekhodi asetafuleni noma ubheke ukuthi uxhuma kuwo. Uma ithebula linamarekhodi wezigidi, ungase ufune ukuhlunga lokhu. Into yokugcina ofuna ukuyenza i-Hang SQL Server.
3. Kubhokisi lengxoxo yeZakhiwo ze-Connection, kunenketho ebizwa ngokuthi "Qala kabusha idatha uma uvula ifayela". Cabanga ngokuhlola lolu khetho. Uma lokhu kukhethwe kuhlolwe, umsebenzisi uzohlala enesethi entsha yedatha lapho evula ispredishithi se-Excel.
4. Cabanga ukusebenzisa amathebula e-Pivot ukuze ufingqa idatha.

Okudingayo

• I-Microsoft Excel 2007
• Idatha ye-SQL Server kufaka phakathi iseva, database kanye netafula noma umbono