Excel Ekupheleni Phambili kwiSQL Server

Umsebenzisi oqhelekileyo ukhululekile ukusebenza kwi- Microsoft Excel . Kutheni ungaboneleli abasebenzisi bakho ngesixhobo abaye bazazi kwaye bonge kuyo uxhumano kwi- SQL Server yakho . Inzuzo yale ndlela i-spreadsheet yabo ye-Excel ihlala isesikhathini kunye neenkcukacha ezikhoyo ezivela kwi-database yokugqibela. Kuqhelekileyo kubasebenzisi ukuba bafake idatha kwi-Excel kodwa ngokuqhelekileyo kuyisitampu seenkcukacha kwinqanaba ngexesha. Eli nqaku liza kukubonisa ukuba kulula kangakanani ukumisela i-spreadsheet ye-Excel kunye noxhumano kwi-SQL onokubonelela kubasebenzisi bakho.

Kulo mzekelo, siza kusebenzisa iSasikethi yeSampula ye-Adventure Works iMicrosoft ithengisa nge-SQL Server 2008.

Ubunzima: Umyinge

Ixesha elifunekayo: imizuzu eyi-10

Lapha & # 39; s Njani

1. Uya kufuna iimpawu ezimbalwa zolwazi ukusetha i-Excel ukuya kwi-SQL Server uxhumano.
   1. • Igama leSQL Server - Ngokomzekelo wethu, iSQL Server yi-MTP \ SQLEXPRESS.
2. Igama ledatha - Umzekelo wethu, sisebenzisa i-AdventureWorks database.
3. Itheyibhile okanye I-View - Silandela umbono wokuthengisa.
4. Vula i-Excel kwaye udale incwadi entsha yomsebenzi.
5. Cofa kwiThebhu yedata. Khangela inketho ethi "Fumana iDatha yangaphandle" kwaye nqakraza kwi "Eminye Imithombo" kwaye ukhethe "Ukusuka kwiSQL Server". Oku kuvula "iWeb Connection Wizard".
6. Gcwalisa igama lomSebenzi . Kulo mzekelo, igama lomncedisi "MTP \ SQLEXPRESS". Setha i-Login Credentials ukuba "Sebenzisa i-Windows Ukuqinisekiswa". Olunye uhlobo luya kusetyenziswa ukuba umphathi wakho wedatha unikezele igama lomsebenzisi kunye nephasiwedi yomsebenzisi wakho. Chofoza Okulandelayo. Oku kuzisa "i-Data Connection Wizard".
7. Khetha isiseko sedatha ("AdventureWorks" kumzekelo wethu) ukusuka "Khetha isiseko sedatha equlethe idatha oyifunayo" yehla ibhokisi. Qinisekisa ukuba "Xhuma kwitafile ethile" ihlolwe. Fumana imbono ("Ukuthengisa kwiVidividualCustomer" kumzekelo wethu) ukusuka kuloluhlu uze ukhethe. Cofa iqhosha elikhupha ibhokisi yencoko yababini yokungenisa.

1. Hlola ibhokisi lebhokisi yokukhetha kwaye ukhethe apho ufuna ukubeka idatha (iphepha lokusebenzela elikhoyo okanye iphepha lokusebenzela elitsha). Cofa Kulungile okwenza uludwe lwe-Excel kwaye ungenisa yonke itafile kwispredishithi sakho.
2. Gcina i-spreadsheet yakho kwaye uthumele kumsebenzisi. Into enhle malunga nale nkqubo kukuba umsebenzisi wakho unako ukufikelela kwidatha ekhoyo xa kunokwenzeka. Nangona idatha igcinwe kwi-spreadsheet, kukho uxhulumaniso kwiSalf Database. Naliphi na ixesha ofuna ukuhlaziya ispredishithi, cofa ngakwesokudla kwitheyibhile uze uklikhe "kwiTable" uze "Hlaziya kwakhona". Yiyo leyo.

Iingcebiso

1. Kubaluleke kakhulu ukuba uqinisekise ukuba umsebenzisi usethe ngokufanelekileyo kwiSQL Server. Le yinto ebangela iimeko kwiimeko ezininzi usebenzisa le ndlela.
2. Hlola inani lamarekhodi asetafileni okanye ujonge ukuba udibanisa. Ukuba itafile inerekhodi yezigidi, unokufuna ukuyifakraza le nto. Into yokugqibela ofuna ukuyenza ixhomeke i-SQL Server.
3. Kwibhokisi yencoko ye-Properties ye-Connection, kukho inketho ebizwa ngokuthi "Hlaziya idatha xa uvula ifayile". Cinga ukujonga oku khetho. Xa olu khetho luhlolwe, umsebenzisi uya kuhlala enesethi entsha yedatha xa evula ispredishithi ye-Excel.
4. Cinga ukusebenzisa i-Pivot Tables ukuze ushwankathe idatha.

Ingaba ufuna ntoni

• Microsoft Excel 2007
• Idatha ye-SQL Server kuquka iseva, database kunye netafile okanye umbono