Ƙarshen Farko na Excel zuwa SQL Server

Mai amfani mai amfani yana jin dadin aiki a cikin Microsoft Excel . Me yasa ba samar da masu amfani tare da kayan aiki da suka riga sun sani ba kuma kara da shi haɗi a cikin yanayin SQL Server . Amfani da wannan hanya shine takardun bayanan na Excel su ne na yau da kullum tare da bayanan yanzu daga bayanan karshen bayanai. Yana da kyau ga masu amfani don saka bayanai a cikin Excel amma yawanci yana da hotunan bayanai a wani lokaci a lokaci. Wannan talifin zai nuna maka yadda mai sauqi ne don saita wani asusun Excel na Excel tare da haɗi zuwa SQL wanda zaka iya samarwa ga masu amfani da ku.

A cikin wannan misalin, zamu yi amfani da bayanan samfurin Adventure Works wanda Microsoft ke aiki tare da SQL Server 2008.

Difficulty: Matsakaici

Lokacin Bukatar: 10 Minti

A nan Ta yaya

1. Za ku buƙaci wasu ƙananan bayanai don saita sauti ga SQL Server.
   1. • Sunan SQL Server - A cikin misali, SQL Server shine MTP \ SQLEXPRESS.
2. Database Name - Misali, muna amfani da AdventureWorks database.
3. Tebur ko Duba - Muna tafiya bayan tallan Sales.vIndividualCustomer.
4. Bude Excel kuma ƙirƙirar sabon littafin littafi.
5. Danna kan Data shafin. Gano "Zaɓin Bayanan Bayani" kuma danna kan "Daga Sauran Sources" kuma zaɓi "Daga SQL Server". Wannan yana buɗewa "Wizard Wizard na Bayanan".
6. Cika cikin Sunan Sunan. A cikin wannan misali, sunan uwar garken shine "MTP \ SQLEXPRESS". Saita takardun shiga zuwa "Yi amfani da Gaskiya na Windows". Za'a yi amfani da wannan zaɓi idan mai sarrafa fayil din ya samar da sunan mai amfani da kalmar wucewa don mai amfani. Danna Next. Wannan yana kawo "Wizard Wizard na Bayanan".
7. Zaɓi bayanan ("AdventureWorks" a cikin misalinmu) daga "Zabi tushen da ke dauke da bayanan da kake son" sauke akwatin. Tabbatar "Haɗa zuwa wani tebur na musamman" an duba. Gano wuri ("Sales.vIndividualCustomer" a misali) daga jerin kuma zaɓi shi. Danna Ƙarshe wanda ya kawo akwatin maganganu Fitarwa.

1. Duba akwatin akwatin kuma zaɓi inda kake so ka saka bayanai (takardun aiki na yanzu ko sabon takardun aiki). Danna Ya yi wanda yake ƙirƙira jerin jerin Excel kuma shigo da dukan tebur a cikin zangonku.
2. Ajiye bayanan da ka aika da mai amfani. Abu mai kyau game da wannan ƙwarewar shine mai amfani naka yana da damar yin amfani da bayanai na yanzu a duk lokacin da suke buƙatar shi. Duk da yake an ajiye bayanan a cikin maƙunsar, akwai haɗin zuwa SQL Database. Kowace lokacin da kake so ka sabunta bayanan, danna danna wani wuri a teburin kuma danna kan "Tebur" sannan sannan "Raɓa". Shi ke nan.

Tips

1. Yana da mahimmanci cewa ka tabbatar mai amfani ya dace a cikin SQL Server. Wannan shine abinda ke haifar da al'amurra a mafi yawan lokuta ta yin amfani da wannan fasaha.
2. Bincika adadin bayanan da ke cikin tebur ko duba cewa kana haɗi zuwa. Idan tebur yana da rubutun mutane miliyan, zaka iya soji wannan. Abu na karshe da kake son yi shine rataya SQL Server.
3. A kan akwatin maganganun Yanki na Connection, akwai wani zaɓi da ake kira "Raɗa bayanai lokacin bude fayil". Yi la'akari da bincika wannan zaɓi. Lokacin da aka duba wannan zaɓin, mai amfani zai koyaushe yana da sabon saitin bayanai lokacin da ke buɗe maƙunsar Labaran Excel.
4. Yi la'akari da yin amfani da maɓallin Pivot don taƙaita bayanan.

Abin da Kake Bukata

• Microsoft Excel 2007
• Bayanan SQL Server ciki har da uwar garken, database da tebur ko duba