Qhov wikiHow no qhia koj yuav ua li cas txuas Excel phau ntawv ua haujlwm rau Oracle database siv Power Query.
Cov kauj ruam
Kauj Ruam 1. Qhib koj phau ntawv ua haujlwm hauv Microsoft Excel
Excel los nrog qhov tshwj xeeb hu ua Power Query (tseem hu ua Get & Transform) uas ua rau nws yooj yim txuas rau Oracle database.
Yog tias koj tsis tau teeb tsa Oracle cov neeg siv software hauv koj lub khoos phis tawj, koj yuav tsum ua li ntawd ua ntej. Koj tuaj yeem tau txais qhov tseeb 64-ntsis version ntawm no, thiab 32-ntsis version ntawm no
Kauj ruam 2. Nyem rau Cov Ntaub Ntawv tab
Nws nyob rau sab saum toj ntawm qhov screen.
Kauj Ruam 3. Nyem Tau Cov Ntaub Ntawv
Yog tias koj tsis pom qhov kev xaiv no, nyem Lus nug tshiab es tsis txhob
Kauj Ruam 4. Nyem Los Ntawm Database
Kauj Ruam 5. Nyem Los Ntawm Oracle Database
Kauj Ruam 6. Nkag mus rau Oracle server lub npe rau hauv ″ Oracle Database ″ lub thawv
Qhov no yuav tsum yog tus tswv tsev lub npe lossis chaw nyob ntawm tus neeg rau zaub mov uas tuav koj lub database.
Yog tias cov ntaub ntawv xav tau SID, siv hom ntawv no los ntaus lub npe server/chaw nyob: servername/SID
Kauj Ruam 7. Nkag mus rau cov lus nug ib txwm muaj hauv ib cheeb tsam (xaiv tau)
Yog tias xa cov ntaub ntawv los ntawm cov ntaub ntawv xav tau cov lus nug tshwj xeeb, nthuav tawm ″ SQL Cov Lus Qhia ″ lub thawv los ntawm txhaj rau daim duab peb sab me me, thiab tom qab ntawd ntaus nqe lus.
Kauj ruam 8. Nyem OK
Qhov no txuag koj cov kev xaiv thiab pib kev sib txuas rau lub database.
Kauj ruam 9. Nkag mus rau hauv lub database
Yog tias cov ntaub ntawv xav kom koj nkag mus, nkag mus rau koj lub npe siv thiab tus lej nkag, thiab tom qab ntawd nyem Txuas. Qhov no txuas cov phau ntawv ua haujlwm rau lub database.
- Nyob ntawm koj qhov chaw, koj kuj tseem yuav tau xaiv txoj hauv kev txheeb xyuas qhov tseeb.
- Yog tias koj nkag mus rau cov lus nug database ib txwm muaj, cov txiaj ntsig yuav tshwm nyob rau hauv Query Editor window.