Se tloaelehileng sa mosebedisi se kgona ho sebetsa Microsoft Excel . Hobaneng u se ke ua fa basebedisi ba hau sesebelisoa seo ba seng ba ntse ba se tseba le ho eketsa ho hokahanya ka tikolohong ea SQL Server . Monyetla oa mokhoa ona ke Excel spreadsheet ea bona e tloaelehileng ho fihlela joale le lintlha tsa morao-rao ho tloha qetellong ea database. Ho tloaelehile hore basebelisi ba behe data Excel empa hangata ke setšoantšo sa data ka nako e itseng. Sehlooho sena se tla u bontša kamoo ho leng bonolo kateng ho lokisa spreadsheet ea Excel ka ho kopanya le SQL eo u ka e fang basebedisi ba hau.
Mohlala ona, re tla sebelisa database ea sample ea Adventure Works eo Microsoft e tsamaisang SQL Server 2008.
Bothata: Karolelano
Nako e Hlokehang: Metsotso e 10
Mona & # 39; s Joang
- U tla hloka lintlha tse 'maloa tsa boitsebiso ho theha khokahanyo ea Excel ho SQL Server.
- Lebitso la SQL Server - Ka mohlala oa rona, SQL Server ke MTP \ SQLEXPRESS.
- Lebitso la Mabitso - Mohlala oa rona, re sebelisa database ea AdventureWorks.
- Letlapa kapa Pono - Re latela pono ea Sales.vIndividualCustomer.
- Bula Excel mme u theha buka e ncha ea mosebetsi.
- Tobetsa tabeng ea Data. Fumana "Find Data Data" ka kopo ebe o tobetsa "Ho tsoa Mehloling e Meng" 'me u khethe "Ho tloha SQL Server". Sena se bula "Moneloi oa Boitsebiso ba Ditshebeletso".
- Tlatsa Lebitso la Server . Mohlala ona, lebitso la seva ke "MTP \ SQLEXPRESS". Beha Credentials Login ho "Sebelisa Windows Authentication". Khetho e 'ngoe e ne e tla sebelisoa haeba mookameli oa hau ea basebetsi a fane ka lebitso la hau le password bakeng sa mosebedisi oa hau. Tlanya E latelang. Sena se hlahisa "Mohokahanyi oa Ditshebeletso tsa Ditshebeletso".
- Khetha database ("AdventureWorks" mohlaleng oa rona) ho tloha "Khetha database e nang le data eo ue batlang" ho theola lebokoseng. Etsa bonnete ba hore "Ho kopanya tafoleng e itseng" ho hlahlojoa. Fumana maikutlo ("Sales.vInvidualCustomer" ka mohlala oa rona) lethathamong le ho le khetha. Tobetsa Finish e hlahisang lebokose la boitsebiso la Import Data.
- Sheba lebokoseng la lebokoseng la Letlapa 'me u khethe moo u batlang ho beha boitsebiso (e leng mosebetsi o fumanehang kapa leqephe le lecha). Tlanya OK e hlahisang lenane la Excel le ho kenya tafole eohle ho spreadsheet ea hau.
- Boloka sahare ea hau 'me u romelle ho mosebedisi. Ntho e ntle mabapi le mokhoa ona ke hore mosebeletsi oa hau o na le boitsebiso ba hona joale ha ho hlokahala. Ha data e ntse e bolokiloe spreadsheet, ho na le ho hokahanya le SQL Database. Neng kapa neng ha o batla ho khatholla sepache, o tobetsa ka ho toba kae-kae tafoleng ebe o tobetsa "Letlapa" ebe o "Refresh". Ho felile ke lehlohonolo.
Litlhahiso
- Ke habohlokoa haholo hore u netefatse hore mochine o setse hantle SQL Server. Sena ke sona se bakang mathata maemong a mangata a sebelisa mokhoa ona.
- Sheba lenane la litlaleho tse leng tafoleng kapa u bone hore na u ikopanya le eng. Haeba tafole e na le litlaleho tsa limilione, u ka 'na ua batla ho e taka fatše. Ntho ea ho qetela eo u batlang ho e etsa ke ho fanyeha SQL Server.
- Ho lebokose la lebokose la Matlotlo a Connection, ho na le khetho e bitsoang "Refresh data ha u bula fono". Nahana ka ho hlahloba khetho ena. Ha kgetho ena e hlahlojoa, mosebeletsi o tla lula a e-na le boitsebiso bo bocha ha a bula Excel spreadsheet.
- Nahana ka ho sebelisa Mathala a Pivot ho akaretsa lintlha.
Seo U se Hlokang
- Microsoft Excel 2007
- Datha ea SQL Server e kenyeletsang seva, database le tafole kapa pono