Ukuvula amafayela e-DBF ku-Microsoft Excel

Esinye sezifomethi zesitoreji esithandwayo kakhulu sedatha ehleliwe yi-DBF. Le fomethi iyonke, okungukuthi, isekelwa izinhlelo eziningi ze-DBMS nezinye izinhlelo. Akusetshenziswanga nje kuphela njengesici sokugcina idatha, kodwa futhi njengendlela yokuwabelana phakathi kwezicelo. Ngakho-ke, inkinga yokuvula amafayela ngesandiso esinikeziwe ku-spreadsheet ye-Excel iba usizo.

Izindlela zokuvula amafayela e-DBF ku-Excel

Kufanele wazi ukuthi kwifomethi ye-DBF ngokwayo kunezinguquko eziningana:

• dBase II;
• dBase III;
• dBase IV;
• FoxPro nabanye

Uhlobo lwamadokhumenti nalo luthinta ukufaneleka kwezinhlelo zayo zokuvula. Kodwa kufanele kuqashelwe ukuthi i-Excel isekela ukusebenza okulungile cishe nawo wonke amafayela e-DBF.

Kumele kuthiwa ezimweni eziningi i-Excel iphendula ngokuvula le fomathi ngokuphumelelayo, okungukuthi, ivula le dokhumenti ngendlela efanayo naloluhlelo oluzovuleka, isibonelo, isakhiwo salo "somdabu" we-xls. Noma kunjalo, i-Excel imise ukulondoloza amafayela kwifomethi ye-DBF ngokusebenzisa amathuluzi avamile emva kwe-Excel 2007. Nokho, lesi sihloko sesifundo esihlukile.

Isifundo: Indlela yokuguqula i-Excel kuya ku-DBF

Indlela 1: sebenzisa iwindi lefayela elivulekile

Enye yezindlela ezilula futhi ezinembile kakhulu zokuvula amadokhumenti nge-.dbf isandiso ku-Excel ukuyivula ngokusebenzisa iwindi lefayela elivulekile.

1. Run Excel bese uya kuthebhu "Ifayela".



2. Ngemva kokufaka ithebhu engenhla, chofoza entweni "Vula" kwimenyu ehlangothini lwesobunxele lwewindi.



3. Iwindi elijwayelekile lemibhalo yokuvula ivuleka. Ukuhambisa kwirekhodi ku-hard drive yakho noma imithombo ekhishwayo, lapho idokhumenti izovulwa khona. Endaweni engezansi engakwesokudla kwewindi, kwiseva lesandiso sesandiso sefayela, setha inkinobho endaweni "Amafayela e-DBase (* .dbf)" noma "Wonke amafayela (*. *)". Lena iphuzu elibaluleke kakhulu. Abasebenzisi abaningi abakwazi ukuvula ifayela ngoba nje abafezi lesi sidingo futhi isici nesandiso esicacisiwe asibonanga kubo. Ngemuva kwalokho, amadokhumenti kwifomathi ye-DBF kufanele avele efasiteleni, uma ekhona kulolu lwemibhalo. Khetha idokhumenti okufanele iqalwe, bese uchofoza inkinobho. "Vula" ekhoneni elingaphansi kwesokudla lewindi.



4. Ngemuva kwesenzo sokugcina, idokhumenti ekhethiwe ye-DBF izosungulwa ku-Excel kushidi.

Indlela 2: chofoza kabili kufayela

Futhi indlela evelele yokuvula amadokhumenti ukuyiqalisa ngokuchofoza kabili inkinobho yegundane lesokunxele kufayela elihambelanayo. Kodwa iqiniso liwukuthi ngokuzenzakalelayo, uma kungenjalo ngokuqondile okushiwo kwisethingi lesistimu, uhlelo lwe-Excel aluhlotshaniswa nesandiso se-DBF. Ngakho-ke, ngaphandle kokusebenza okungeziwe ngale ndlela, ifayela alikwazi ukuvulwa. Ake sibone ukuthi lokhu kungenziwa kanjani.

1. Ngakho, chofoza kabili inkinobho yegundane lesokunxele kufayela le-DBF esifuna ukulivula.



2. Uma kule khompyutha kuzilungiselelo zesistimu ifomethi ye-DBF ayihlotshaniswa nanoma yiluphi uhlelo, khona-ke iwindi lizoqala, okuzobonisa ukuthi ifayela alikwazanga ukuvulwa. Izohlinzeka ngezinketho zesenzo:
   • Sesha ukufaniswa ku-inthanethi;
   • Khetha uhlelo oluvela ohlwini lwezinhlelo ezifakiwe.

   Njengoba kucatshangwa ukuthi ispredishithi se-Microsoft Excel yinkambinkimbi sesivele ifakiwe, sisusa ukushintshela endaweni yesibili bese uchofoza inkinobho "Kulungile" phansi kwefasitela.

   

   Uma lesi sandiso sesivele sihlotshaniswa nenye uhlelo, kodwa sifuna ukuyiqhuba ku-Excel, bese senza kancane kancane. Chofoza igama ledokhumenti ngenkinobho yesinxele yesokudla. Iqala imenyu yokuqukethwe. Khetha isikhundla kuso "Vula nge". Olunye uhlu luvulwa. Uma inegama "I-Microsoft Excel", bese uchofoze kuwo, kodwa uma ungatholi igama elinjalo, ke ungena kulowo nto "Khetha uhlelo ...".

   

   Kunenye indlela. Chofoza igama ledokhumenti ngenkinobho yesinxele yesokudla. Kulolu hlu oluvula emva kwesenzo sokugcina, khetha isikhundla "Izakhiwo".

   

   Ewindini elisebenzayo "Izakhiwo" thuthela kuthebhu "Jikelele"uma ukuqaliswa kwenzeka nakwezinye ithebhu. Mayelana nepharamitha "Isicelo" cindezela inkinobho "Shintsha ...".



3. Uma ukhetha noma iyiphi yezinketho ezintathu, iwindi lokuvula ifayela lizovula. Futhi, uma uhlu lwezinhlelo eziphakanyisiwe ezingxenyeni ezingaphezulu kwewindi liqukethe igama "I-Microsoft Excel"bese uchofoza kuso, kungenjalo chofoza inkinobho "Buyekeza ..." phansi kwefasitela.



4. Endabeni yesenzo sokugcina esihlalweni sendawo yohlelo kwikhompyutheni, iwindi livuleka "Vula nge ..." ngesimo se-Explorer. Kuyo, iya kwifolda equkethe ifayela le-Excel yokuqalisa. Ikheli eliqondile lendlela eya kule folda kuxhomeke ku-version ye-Excel oyifakile, noma kunalokho ku-version ye-Microsoft Office. Umklamo wendlela jikelele uzobukeka kanje:

   C: Uhlelo lwezinhlelo Microsoft Office Office #

   Esikhundleni somlingiswa "#" Kudingeka ukuthi ufake indawo yenguqulo yomkhiqizo wakho wehhovisi. Ngakho nge-Excel 2010 lokhu kuzoba inombolo "14"Futhi indlela eqondile eya kwifolda izobukeka kanje:

   C: Uhlelo Lwezinhlelo Microsoft Office Office14

   Ku-Excel 2007, inombolo izoba "12"I-Excel 2013 - "15"i-Excel 2016 - "16".

   Ngakho-ke, hamba ku-directory engenhla bese ubuka ifayela ngegama "EXCEL.EXE". Uma ukumeleka kwebalazwe kungasebenzi ohlelweni lwakho, igama layo lizobonakala lifana nje "EXCEL". Khetha igama bese uchofoza inkinobho. "Vula".



5. Emva kwalokho, sithunyelwa ngokuzenzakalelayo ewindini lokukhetha uhlelo. Lesi sikhathi leli gama "I-Microsoft Office" izoboniswa ncamashi lapha. Uma umsebenzisi efuna lolu hlelo lokusebenza luhlale luvulekile amadokhumenti e-DBF ngokuchofoza kabili kubo ngokuzenzakalelayo, khona-ke kudingeka uqiniseke ukuthi "Sebenzisa uhlelo olukhethiwe kuwo wonke amafayela alolu hlobo" kufanelekile umkhawulo. Uma uhlela kuphela ukuvula okulodwa kwedokhumenti ye-DBF ku-Excel, bese uzovula lolu hlobo lwamafayela kwenye uhlelo, ngakho-ke, ngokuphambene, leli bhokisi lokuhlola kufanele lisuswe. Ngemuva kokuthi zonke izilungiselelo ezicacisiwe zenziwe, chofoza inkinobho. "Kulungile".



6. Ngemuva kwalokhu, idokhumenti ye-DBF izosungulwa ku-Excel, futhi uma umsebenzisi ekhetha indawo efanele ewindini lokukhetha uhlelo, amafayela walesi sandiso azovuleka ku-Excel ngokuzenzekelayo ngemva kokuchofoza kabili kubo ngenkinobho yegundane lesokunxele.

Njengoba ungabona, ukuvula amafayela e-DBF ku-Excel kulula kakhulu. Kodwa, ngeshwa, abasebenzisi abaningi be-novice badidekile futhi abazi ukuthi bangayenza kanjani. Isibonelo, abaqageli ukusetha ifomethi efanele efasiteleni ukuvula idokhumenti ngokusebenzisa i-Excel interface. Okulukhuni nakakhulu kubasebenzisi abathile ukuvula imibhalo ye-DBF ngokuchofoza kabili inkinobho yegundane lesokunxele, ngoba lokhu kuyadingeka ushintshe izilungiselelo ezithile zesistimu ngokusebenzisa iwindi lokukhetha uhlelo.