Excel End End kune SQL Server

Izvo zvinoshandiswa nevashandi zvinonakidza kushanda muMicrosoft Excel . Wadii kupa vashandi vako nechigoni chavanenge vachiziva uye kuwedzera kwazviri kuwirirana muSQL Server yako . Kubudirira kweizvi nzira yavo ye Excel spreadsheet inogara ichikwaniswa ne data ikozvino kubva kumashure ekupedzisira database. Izvi zvinowanzoitirwa vashandisi kuisa data kuExcel asi kazhinji iri mufananidzo we data pane imwe nguva nenguva. Ichi chinyorwa chichakuratidza kuti zviri nyore sei kugadzirisa Excel spreadsheet nekubatana neSQL yaunogona kupa vashandisi vako.

Mumuenzaniso uyu, tichaenda kushandisa database yeAventure Works shanduro iyo Microsoft inotakura neSQL Server 2008.

Dambudziko: Avhareji

Nguva Yakakodzera: Maminitsi 10

Pano & # 39; s Sei

1. Iwe unoda zvishoma zviduku zvemashoko kuti uise purogiramu ye Excel kusvika SQL Server.
   1. • SQL Server Name - Muenzaniso wedu, SQL Server ndeye MTP \ SQLEXPRESS.
2. Dhiyabhorosi Zita - Muenzaniso wedu, tiri kushandisa database yeAventureWorks.
3. Tafura kana View - Tiri kutevera maonero ekuThengesa.VIndividualCustomer.
4. Vhura Excel uye tanga bhuku idzva rebasa.
5. Dzvanya paData Data tab. Tsvaga i "Get External Data" uye sarudza pa "Kubva Mimwe Sources" uye sarudza "Kubva kuSQL Server". Izvi zvinovhura "Data Connection Wizard".
6. Zadza muZita reSeva . Mumuenzaniso uyu, zita revhareti "MTP \ SQLEXPRESS". Gadzira Login Credentials ku "Shandisa Windows Authentication". Iyo imwe sarudzo inoshandiswa kana iwe wekutengesa mabhuku epa database achipa zita rekushandisa nephasiwedi yemushandisi wako. Dhinda Kutevera. Izvi zvinounza "Data Connection Wizard".
7. Sarudza database ("AdventureWorks" mumuenzaniso wedu) kubva "Sarudza dhesiyo ine deta yaunoda" inodonha bhokisi. Iva nechokwadi chokuti "Kubatanidza kune tafura imwe" inotariswa. Tsvaga maonero ("Sales.VIndividualCustomer" mumuenzaniso wedu) kubva pakurongwa uye sarudza. Dhinda Finish iyo inounza Up Import Data dialog box.

1. Tarisa Tafura yebhokisi yekutarisa uye sarudza kwaunoda kuisa data (iripo worksheet kana pepa rekushanda). Dzvanya OK izvo zvinogadzira Excel urongwa uye inopinza tafura yose muchipupuriro chako.
2. Chengetedza festiroti yako uye tumira kumushandisi. Chinhu chakanaka pamusoro pegadziriro iyi ndechokuti mushumiri wako ane ruzivo rwezvinobvira pese pavanenge vachida. Kunyange zvazvo deta iri kuchengetwa mune pepanheti, pane kuwirirana kuSquL Database. Chero nguva chero ipi zvayo yaunoda kudzorera sarashiti, tsanangurira pane imwe nzvimbo patafura uye tora pa "Table" uye "Ongorora". Ndizvo.

Mazano

1. Zvinonyanya kukosha kuti iwe uone kuti mushandisi akagadzirisa zvakakodzera muSQL Server. Ichi ndicho chinhu chinokonzera nhau mumatambudziko akawanda uchishandisa nzira iyi.
2. Chengeta nhamba yezvinyorwa zviri mutafura kana kuona kuti uri kuunganira. Kana iyo tafura ine zvinyorwa zvemamiriyoni, ungada kufuta izvi pasi. Chinhu chekupedzisira chamunoda kuita ndeche SQL Server.
3. PaConnection Properties box box, pane sarudzo inonzi "Vhurazve data kana uzarura faira". Funga kuongorora izvi. Kana izvi zvinosarudzwa, mushumiri achagara aine data itsva pakudhura shanduro yeExpcel.
4. Funga kushandisa Pivot Tables kuti ufukidze data.

Zvaunoda

• Microsoft Excel 2007
• SQL Server data kusanganisira server, database uye tafura kana maonero