Qhib DBF cov ntaub ntawv hauv Microsoft Excel

Ib qho ntawm feem ntau hom kev tawm tswv yim rau kev qhia ntaub ntawv yog DBF. Hom ntawv no yog universal, uas yog, nws muaj ntau yam kev pabcuam DBMS thiab lwm yam kev pabcuam. Nws yog siv tsis yog lub hauv paus rau kev khaws cia cov ntaub ntawv, tab sis kuj yog ib qho kev pab rau kev sib qhia ntawm cov ntawv. Yog li, qhov teeb meem ntawm qhib cov ntaub ntawv nrog ib qhov muab ncua hauv ib qho Excel spreadsheet ua tseem ceeb.

Txoj kev qhib DBF cov ntaub ntawv hauv Excel

Koj yuav tsum paub tias nyob rau hauv DBF hom nws tus kheej muaj ntau cov kev hloov kho:

• dBase II;
• dBase III;
• dBase IV;
• FoxPro thiab lwm tus

Hom ntawm daim ntawv tseem cuam tshuam qhov tseeb ntawm nws cov kev pab qhib. Tab sis nws yuav tsum tau muab sau tias Excel txhawb cov lag luam uas muaj txhua hom DBF cov ntaub ntawv.

Nws yuav tsum tau hais tias feem ntau ntawm Excel copes nrog qhib ntawm hom ntawv no ntse heev, yog li, qhib tsab ntawv no tib yam nkaus li qhov kev qhia no yuav qhib, piv txwv li, nws tus kheej "xls" hom ntawv xls. Txawm li cas los, Excel tau tso tseg cov ntaub ntawv hauv DBF hom siv cov cuab yeej txheem tom qab Excel 2007. Txawm li cas los xij, qhov no yog lub ntsiab lus rau ib qho kev qhia txawv.

Tshooj: Yuav ua li cas hloov Excel rau DBF

Txoj kev 1: khiav los ntawm cov ntaub ntawv qhib qhov rai

Ib qho yooj yim thiab feem ntau txoj hauv kev qhib cov ntaub ntawv qhib nrog .dbf extension hauv Excel yog tso tawm lawv los ntawm qhib qhov rai.

1. Khiav Excel thiab mus rau lub tab "Cov Ntaub Ntawv".



2. Tom qab nkag mus rau saum toj ntawv, nyem rau ntawm qhov khoom "Qhib" nyob rau hauv cov zaub mov uas nyob rau sab laug ntawm lub qhov rais.



3. Lub qhov rais qhib rau cov ntaub ntawv qhib tau qhib. Tsiv mus rau cov npe ntawm koj tus tsav nyuab los yog tshem tawm, qhov twg yog qhov qhib rau hauv daim ntawv. Nyob rau hauv sab qis txoj cai ntawm lub qhov rais, nyob rau hauv cov ntaub ntawv txuas ntxiv mus rau qhov chaw, teem caij mus rau txoj haujlwm "Cov ntaub ntawv DBase (* .dbf)" los yog "Txhua Ntaub Ntawv (*. *)". Qhov no yog qhov tseem ceeb heev. Ntau cov neeg siv tsis tuaj yeem qhib cov ntaub ntawv tsuas yog vim lawv tsis ua raws li qhov yuav tsum tau ua thiab lub caij nrog qhov kev qhia txuas ntxiv tsis pom lawv. Tom qab ntawd, cov ntaub ntawv hauv DBF hom yuav tsum tshwm sim hauv lub qhov rais, yog tias lawv nyob hauv phau ntawv no. Xaiv cov ntawv uas yuav tsum tau khiav, thiab nyem rau ntawm lub pob. "Qhib" nyob rau hauv qis txoj cai kaum ntawm lub qhov rais.



4. Tom qab qhov kawg nkaus, daim ntawv xaiv DBF yuav muab tso rau hauv Excel rau ntawm daim ntawv.

Txoj kev 2: ob npaug nias rau hauv cov ntaub ntawv

Kuj yog ib txoj hauv kev qhib cov ntaub ntawv qhib rau nws yog siv ob zaug-nrog lub pob nyem khawm ntawm cov ntaub ntawv coj los siv. Tab sis qhov tseeb yog qhov ua tsis tau, yog tias tsis yog hais nyob rau hauv cov chaw siv, qhov kev pab cuam Excel tsis cuam tshuam nrog DBF ncua. Yog li, tsis muaj ntxiv manipulations nyob rau hauv txoj kev no, cov ntaub ntawv tsis tau qhib. Cia peb pom tias qhov no yuav ua li cas.

1. Li ntawd, ob-nias nrog lub nas khawm laug ntawm DBF cov ntaub ntawv peb xav qhib.



2. Yog tias hom ntawv DBF tsis cuam tshuam nrog ib qho kev pab cuam hauv lub computer no rau hauv qhov system, qhov rais pib, uas yuav qhia rau koj tias cov ntaub ntawv yuav tsis qhib. Nws yuav muab cov kev xaiv rau kev nqis tes ua:
   • Tshawb nrhiav hauv online;
   • Xaiv ib qhov kev zov me nyuam los ntawm daim ntawv teev cov kev pab cuam ntsia.

   Vim nws yog assumed tias cov ntaub ntawv spreadsheet Microsoft Excel processor twb ntsia, peb tsiv mus rau tus tes hloov mus rau ob txoj hauj lwm thiab nias rau ntawm lub pob "OK" nyob hauv qab ntawm qhov rais.

   

   Yog tias qhov kev txuas ntxiv no twb txuas nrog lwm qhov kev pab cuam, tab sis peb xav khiav nws hauv Excel, ces peb ua tus me ntsis txawv. Nias rau ntawm daim ntawv lub npe nrog tus mouse nas khawm. Launches lub ntsiab lus teb lus qhia. Xaiv ib txoj hauj lwm hauv nws "Qhib nrog". Lwm daim ntawv qhib. Yog tias nws muaj lub npe "Microsoft Excel", ces nias rau nws, tab sis yog tias koj tsis pom zoo li lub npe, ces mus dhau qhov khoom "Xaiv ib qhov kev pab cuam ...".

   

   Muaj lwm txoj hau kev. Nias rau ntawm daim ntawv lub npe nrog tus mouse nas khawm. Nyob rau hauv cov npe uas qhib tom qab qhov kawg kiag, xaiv qhov chaw "Cov khoom".

   

   Hauv lub qhov rai khiav "Cov khoom" txav mus rau tab "General"yog lub tso tawm hauv lwm qhov tab. Txog parameter "Thov" nias lub khawm "Hloov ...".



3. Yog tias koj xaiv ib qho ntawm peb txoj kev xaiv, cov ntaub ntawv qhib qhov rai yuav qhib. Ntxiv dua thiab, yog tias daim ntawv teev cov kev pom zoo rau hauv phab ntsa sab nraud muaj lub npe "Microsoft Excel"ces nias rau nws, txwv tsis pub nyem rau ntawm lub pob "Ntsuam xyuas ..." nyob hauv qab ntawm qhov rais.



4. Nyob rau hauv cov ntaub ntawv ntawm qhov kawg nkaus nyob rau hauv qhov chaw zov me nyuam qhov chaw teev npe ntawm lub tshuab computer, lub qhov rais qhib "Qhib nrog ..." nyob rau hauv daim ntawv ntawm Explorer. Nyob rau hauv nws, mus rau lub nplaub tshev uas muaj cov ntaub ntawv Excel pib. Qhov chaw seem ntawm txoj kev mus rau lub nplaub tshev no yog nyob ntawm version ntawm Excel uas koj tau ntsia, lossis theej rau ntawm Microsoft Office. Txoj kab zuag qhia tag nrho yuav zoo li no:

   C: Cov Kev Pab Cuam Cov Ntaub Ntawv Microsoft Office Office #

   Es tsis txhob ua cim "#" Nws yuav tsum tau hloov tus xov tooj ntawm koj qhov chaw ua haujlwm. Yog li rau Excel 2010 no yuav yog tus naj npawb "14"Thiab txoj kev kos rau daim nplaub tshev yuav zoo li no:

   C: Cov ntaub ntawv Microsoft Office Office14

   Rau Excel 2007, tus naj npawb yuav yog "12"rau Excel 2013 - "15"rau Excel 2016 - "16".

   Li ntawd, txav mus rau cov npe saum toj no thiab saib cov ntaub ntawv nrog lub npe "EXCEL.EXE". Yog hais tias qhov kev ncua ntev tsis khiav ntawm koj lub cev, nws lub npe yuav zoo nkaus li "HNAV". Xaiv lub npe thiab nyem rau ntawm lub pob. "Qhib".



5. Tom qab ntawd, peb mam li xa rov qab mus rau qhov kev xaiv xaiv qhov rais. Lub sij hawm no lub npe "Microsoft Office" nws yuav tsum tau tso tawm kom pom tseeb ntawm no. Yog hais tias tus neeg siv xav daim ntawv thov no yuav tsum qhib DBF cov ntaub ntawv txhua zaus los ntawm ob zaug-txhaj rau lawv ua ke, ces koj yuav tsum nco ntsoov tias "Siv cov kev xaiv xaiv rau tag nrho cov ntaub ntawv ntawm hom no" muaj nqis zuam. Yog tias koj npaj tsuas qhib ib daim ntawv DBF hauv Excel, thiab ces koj yuav qhib hom ntaub ntawv no hauv lwm qhov kev pab, ces, ntawm qhov tsis sib xws, daim tshev khawm no yuav tsum tau muab tshem tawm. Tom qab tag nrho cov chaw teev lus tau tsim, nyem rau ntawm lub pob. "OK".



6. Tom qab qhov no, DBF daim ntawv yuav muab tso rau hauv Excel, thiab yog tias tus neeg siv xaiv qhov chaw tsim nyog hauv qhov kev xaiv qhov rais, ces cov ntaub ntawv ntawm qhov kev txuas ntxiv no yuav qhib hauv Excel tom qab ob zaug txhaj rau lawv nrog tus nas laug khawm.

Raws li koj tau pom, qhib DBF cov ntaub ntawv nyob rau hauv Excel yog yooj yim heev. Tab sis, hmoov tsis, ntau cov neeg siv novice tsis meej pem thiab tsis paub yuav ua li cas. Piv txwv li, lawv tsis twv los tsim hom ntawv tsim nyog hauv lub qhov rais kom qhib ib daim ntawv los ntawm Excel interface. Txawm nyuaj rau qee cov neeg siv yog qhib DBF cov ntaub ntawv los ntawm ob npaug rau sab laug nas khawm, txij li qhov no koj yuav tsum hloov qee qhov chaw siv los ntawm qhov kev xaiv qhov rai.