Kab lus no yuav coj cov neeg siv los ntxig SQL cov lus nug hauv Excel 2010 thiab tsim kev sib txuas zoo.
Kauj ruam
Kauj Ruam 1. Nyem rau Cov Ntaub Ntawv tab, tom qab ntawv xaiv Los Ntawm Lwm Qhov Chaw raws li qhia hauv qab no duab
Kauj Ruam 2. Xaiv "Los Ntawm Cov Ntaub Ntawv Txuas Txuas" los ntawm cov ntawv qhia zaub mov nco
Kauj Ruam 3. Qhov Kev Pabcuam Cov Ntaub Ntawv Txuas Txuas qhov rai yuav qhib
Xaiv "ODBC DSN" los ntawm cov kev xaiv muaj, tom qab ntawv nyem "Tom ntej".
Kauj Ruam 4. Lub qhov rai ODBC Cov Ntaub Ntawv Cov Ntaub Ntawv yuav qhib thiab tso saib cov npe ntawm cov chaw khaws cia hauv lub koom haum
Xaiv cov ntaub ntawv tsim nyog, tom qab ntawv nyem "Tom ntej".
Kauj Ruam 5. Qhov Xaiv Database thiab Table window yuav tshwm
Kauj Ruam 6. Tam sim no koj tuaj yeem xaiv lub database thiab cov lus uas muaj cov ntaub ntawv koj xav rub
Xaiv cov ntaub ntawv tsim nyog.
Kauj Ruam 7. Nyem Ua tiav ntawm "Txuag Cov Ntaub Ntawv Txuas Cov Ntaub Ntawv thiab Ua tiav" qhov rai
Lub qhov rai yuav tso saib cov npe ntaub ntawv raws li cov ntaub ntawv xaiv ntawm lub vijtsam dhau los.
Kauj Ruam 8. Qhov Ntshuam Cov Ntaub Ntawv qhov rai yuav tshwm sim
Hauv lub qhov rai no, xaiv cov ntaub ntawv tsim nyog, tom qab ntawd nyem "OK".
Kauj Ruam 9. Xaiv "Los ntawm Cov Ntaub Ntawv Txuas Txuas" los ntawm cov ntawv qhia zaub mov nco
Kauj Ruam 10. Nyem rau Cov Ntaub Ntawv tab, tom qab ntawd nyem Txuas
Hauv lub qhov rai tom ntej, nyem Properties.
Kauj Ruam 11. Qhib Cov Lus Txhais tab hauv lub qhov rai tom ntej
Kauj Ruam 12. Sau SQL cov lus nug hauv kab lus "Command Text", tom qab ntawv nyem "OK"
Excel yuav tso saib cov lus nug cov ntaub ntawv.
