Ungalivula kanjani ifayela le-DBF ku-Excel

Enye yezindlela ezithandwa kakhulu zokugcina zedatha ehlelekile yi-DBF. Le fomethi ihlukaniswa yi-Universal, okungukuthi, isekelwa izinhlelo eziningi ze-DBMS kanye nezinye izinhlelo. Kusetshenziswa hhayi kuphela njengento yokugcina idatha, kodwa futhi njengendlela yokushintshana phakathi kwezicelo. Ngakho-ke, umbuzo wokuvula amafayela nalesi sandiso ku-Excel Table Propector esebenza kahle.

Izindlela zokuvula amafayela we-DBF ku-Excel

Kufanele wazi ukuthi kunokuguqulwa okuningana ngefomethi ye-DBF:

• I-DBase II;
• Dbase III;
• Dbase IV;
• FoxPro et al.

Uhlobo lwedokhumenti futhi luthinta ukunemba kwezinhlelo zalo zokuvula. Kepha kufanele kuqashelwe ukuthi i-Excel isekela ukusebenza okulungile cishe nazo zonke izinhlobo zamafayela we-DBF.

Kufanele kushiwo ukuthi ezimeni eziningi zikhuluma kahle nangokuvulwa kwale fomethi ngempumelelo, okungukuthi, kuvulela lo mbhalo njengoba lolu hlelo luzovulwa, ngokwesibonelo, amafomethi awo "abomdabu". Kepha ukusindisa amafayela ngefomethi ye-DBF ngamathuluzi ajwayelekile, ama-Excel amise ngemuva kwe-Excel 2007 version. Noma kunjalo, lesi yisihloko esifundweni esihlukile.

Isifundo: Ungahumusha kanjani ama-Excel ku-DBF

Indlela 1: Qala ngewindi lokuvula ewindini

Enye yezinketho ezilula futhi ezinembile zokuvula amadokhumenti ngokunwetshwa kwe-DBF ku-Excel ukuwaqala ngewindi lokuvula iwindi.

1. Qalisa uhlelo lwe-Excel bese uya kuthebhu yefayela.



2. Ngemuva kokufaka ithebhu engenhla, chofoza entweni ethi "Vula" kumenyu etholakala ohlangothini lwesobunxele lwewindi.



3. Iwindi lokuvula ledokhumenti elijwayelekile livula. Sithuthela kulolo mkhombandlela ku-hard disk noma i-shift carrier, lapho idokhumenti itholakala khona ukuvula. Ngakwesokunene sewindows kwi-File Extensions, setha ukushintshela kumafayili we- "Dbase (* .dbf)" noma "wonke amafayela (*. *)". Leli iphuzu elibaluleke kakhulu. Abasebenzisi abaningi abakwazi ukuvula ifayela ngoba nje bengazifezi le mfuneko kanye nento enokwandisa okucacisiwe abakubonakali. Ngemuva kwalokho amadokhumenti e-DBF kufanele akhonjiswe ewindini uma ekhona kule khathalogu. Sabela idokhumenti ofuna ukuyisebenzisa, bese uqhafaza inkinobho ethi "Vula" ekhoneni elingezansi kwesokudla sewindi.



4. Ngemuva kwesenzo sokugcina, idokhumenti ye-DBF ekhethiwe izokwethulwa kuhlelo lwe-Excel eshidini.

Indlela 2: Ukuchofoza kabili

Futhi indlela ethandwayo yokuvula amadokhumenti ukwethulwa ngokuchofoza kabili nge-Feak Mouse Inkinobho efayilini elihambisanayo. Kepha iqiniso ngukuthi ngokuzenzakalelayo, uma ikakhulukazi ukungakunqume kuzilungiselelo zohlelo, uhlelo lwe-Excel aluhlotshaniswa nesandiso se-DBF. Ngakho-ke, ngaphandle kokusebenzisa okwengeziwe, ngale ndlela ayisebenzi. Ake sibheke ukuthi kungenziwa kanjani.

1. Ngakho-ke, sichofoza kabili inkinobho yegundane kwesobunxele eduze kwefayela lefomethi ye-DBF, esifisa ukulivula.



2. Uma kule khompyutha kuzilungiselelo zesistimu, ifomethi ye-DBF ayihlotshaniswa nanoma yiluphi uhlelo, iwindi lizoqala, elingeke libikwe ukuthi ifayela alikwazi ukuvulwa. Izonikeza izinketho zesenzo:
   • Sesha ukuvumelana kwi-Intanethi;
   • Khetha uhlelo ohlwini lwezinhlelo ezifakiwe.

   Njengoba kuqondakala ukuthi i-Microsoft Excel Tabulaler Propector isivele ifakiwe, sihlele kabusha ukushintshela esimweni sesibili bese uchofoza kukhiye we- "OK" ezansi kwewindi.

   

   Uma lokhu kunwetshwa sekuvele kuhlotshaniswa nolunye uhlelo, kepha sifuna ukuluhambisa ngokugqamile, khona-ke sikwenza ngendlela ehlukile. Chofoza igama ledokhumenti chofoza kwesokudla. Imenyu yomongo yethulwa. Khetha isikhundla esithi "Vula ngosizo" kuyo. Olunye uhlu luyavula. Uma kunegama elithi "Microsoft Excel", bese uchofoza kulo, uma ungalitholi igama elinjalo, singena entweni ethi "Khetha uhlelo ...".

   

   Kukhona enye inketho. Chofoza igama ledokhumenti chofoza kwesokudla. Uhlu oluvula ngemuva kwesenzo sokugcina, khetha isikhundla "Izakhiwo".

   

   Ewindows "Properties", sithuthela kuthebhu ethi "General", uma ukwethulwa kwenzeka kwenye ithebhu. Eduze nepharamitha yesicelo, chofoza inkinobho ethi "Hlela ...".



3. Uma ukhetha noma yiziphi izinketho ezintathu, iwindi lokuvula ifayili liqalisiwe. Futhi, uma ohlwini lwezinhlelo ezinconyiwe phezulu kwewindows kukhona igama elithi "Microsoft Excel", bese uchofoza kulo, futhi esimweni esiphikisanayo esichofoza kukhomba " iwindi.



4. Uma kwenzeka isenzo sokugcina kuhlelo lwendawo yohlelo, "vula ngosizo lwe ..." luvulwa kwikhompyutha. Kudinga ukuya kwifolda equkethe uhlelo lokuqalisa uhlelo lwe-Excel. Ikheli eliqondile lendlela eya kule folda lincike kwinguqulo ye-Excel, oyifakile, noma kunalokho kusuka kunguqulo yephakethe le-Microsoft Office. Iphethini yendlela ejwayelekile izobukeka kanjena:

   C: \ Amafayela wohlelo \ Microsoft Office \ Office #

   Esikhundleni sophawu lwe- "#", udinga ukufaka esikhundleni inombolo yenguqulo yomkhiqizo wehhovisi lakho. Ngakho-ke nge-Excel 2010 kuzoba inombolo "14", futhi indlela ngqo kwifolda izobukeka kanjena:

   C: \ amafayela wohlelo \ Microsoft Office \ Office14

   Ngomphumela we-Excel 2007, inani lizoba "12", ngoba i-Excel 2013 - "15", ngokwe-Excel 2016 - "16".

   Ngakho-ke, sithuthela esikhwameni esingenhla futhi sifuna ifayela ngegama elithi "Excel.exe". Uma ungaqhubeki isibonisi sokunwetshwa ohlelweni, igama laso lizobukeka njenge- "Excel". Sabela leli gama bese uchofoza inkinobho ethi "Open".



5. Ngemuva kwalokho, siphinde sidluliselwe futhi ewindini lokukhetha uhlelo. Okwamanje igama elithi "Microsoft Office" nakanjani lizokhonjiswa lapha. Uma umsebenzisi efuna lolu hlelo lokusebenza avule amadokhumenti e-DBF ngu-DBF Dual Chofoza kuzo, khona-ke udinga ukuqiniseka ukuthi "sebenzisa uhlelo olukhethiwe kuwo wonke amafayela alolu hlobo" luwuphawu lokuhlola. Uma uhlela kuphela idokhumenti elilodwa le-DBF elivulekile ku-Excel, bese uyovula lolu hlobo lwamafayela kolunye uhlelo, khona-ke, ngokuhlukile, leli phawula lokuhlola kufanele lisuswe. Ngemuva kwazo zonke izilungiselelo ezichaziwe zenziwa, chofoza inkinobho ethi "Kulungile".



6. Ngemuva kwalokho, idokhumenti ye-DBF izoqhutshwa ohlelweni lwe-Excel, futhi uma umsebenzisi ebeka umkhaza endaweni efanelekile ewindini lokukhetha uhlelo, manje amafayela azokwengeza azovulwa ngokuzenzakalelayo ngemuva kokuchofoza kabili ngakwesobunxele inkinobho yegundane.

Njengoba ukwazi ukubona, vula amafayela we-DBF ku-Excel alula impela. Kepha, ngeshwa, abasebenzisi abaningi be-novice badidekile futhi abazi ukuthi bakwenze kanjani. Isibonelo, abaqageli ukusetha ifomethi efanelekile ewindini lokuvula ledokhumenti ngokusebenzisa isikhombimsebenzisi se-exel. Kunzima okwengeziwe kwabanye abasebenzisi ukuvulwa kwemibhalo ye-DBF ngokuchofoza kabili inkinobho yegundane kwesobunxele, ngoba lokhu udinga ukushintsha ezinye izilungiselelo zohlelo ngewindi lokukhetha uhlelo.