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