Fayilolin DBF budewa a cikin Microsoft Excel

Ɗaya daga cikin samfurin ajiya mafi mashahuri don bayanan tsarin shine DBF. Wannan tsari ne na duniya, wato, yana da goyon baya da yawancin tsarin DBMS da wasu shirye-shiryen. An yi amfani dashi ba kawai a matsayin wani ɓangare don adana bayanai ba, har ma a matsayin hanyar don raba su tsakanin aikace-aikace. Sabili da haka, batun bude fayiloli tare da tsawo da aka ba da shi a cikin takarda na Excel ya zama mai dacewa sosai.

Hanyar bude fayiloli DBF a Excel

Ya kamata ku sani cewa a cikin tsarin DBF kanta akwai wasu gyare-gyare:

• dBase II;
• dBase III;
• dBase IV;
• FoxPro da sauransu

Nau'in takardun kuma yana tasiri daidai da shirye-shirye na budewa. Amma ya kamata a lura cewa Excel na goyan bayan aiki mai kyau da kusan dukkanin fayilolin DBF.

Ya kamata a ce a cikin mafi yawancin lokuta Excel ya shiga tare da buɗe wannan tsari wanda aka samu nasara sosai, wato, ya buɗe wannan takarda a daidai yadda wannan shirin zai buɗe, alal misali, tsarin kansa na "asali" na xls. Duk da haka, Excel ya dakatar da fayilolin ajiya a cikin tsarin DBF ta amfani da kayan aiki na asali bayan Excel 2007. Duk da haka, wannan batu ne don darasi na daban.

Darasi: Yadda zaka canza Excel zuwa DBF

Hanyar 1: gudu ta cikin fayil din bude fayil

Ɗaya daga cikin hanyoyin da ya fi dacewa da kuma mafi mahimmanci don buɗe takardun tare da .dbf tsawo a Excel shi ne kaddamar da su ta hanyar bude fayil ɗin bude fayil.

1. Run Excel kuma je zuwa shafin "Fayil".



2. Bayan shigar da shafin da ke sama, danna kan abu "Bude" a menu wanda yake a gefen hagu na taga.



3. Gilashin ma'auni don bude takardun ya buɗe. Ƙaura zuwa shugabanci a kan rumbun kwamfutarka ko kafofin watsa labaru masu sauya, inda za'a bude bayanin. A cikin ƙananan dama na ɓangaren taga, a cikin fayil ɗin fadakar fayil ɗin sauyawa, saita yanayin zuwa wurin "Fayil din fayiloli (* .dbf)" ko "Duk Files (*. *)". Wannan abu ne mai mahimmanci. Masu amfani da yawa ba za su iya bude fayil ɗin ba kawai saboda basu cika wannan buƙatar ba kuma ba'a ganin su ba. Bayan haka, takardu a cikin tsarin DBF ya kamata su bayyana a taga, idan sun kasance a cikin wannan shugabanci. Zaɓi abin da ya kamata a gudanar, kuma danna maballin. "Bude" a cikin kusurwar dama na taga.



4. Bayan aikin karshe, za a fara daftarin aikin DBF da aka zaɓa a Excel a kan takardar.

Hanyar 2: danna sau biyu a fayil

Har ila yau, hanyar da za a iya buɗewa ita ce ta kaddamar da shi ta hanyar dannawa sau biyu tare da maɓallin linzamin hagu a kan fayil ɗin daidai. Amma gaskiyar ita ce ta hanyar tsoho, idan ba a tsara shi a cikin tsarin tsarin ba, shirin na Excel ba ya haɗuwa da tsawo na DBF. Sabili da haka, ba tare da ƙarin maniputa ta wannan hanya ba, ba za a bude fayil din ba. Bari mu ga yadda za ayi wannan.

1. Saboda haka, muna danna sau biyu a kan fayil na DBF da muke so mu bude.



2. Idan tsarin DBF ba'a hade da kowane shirin a kan wannan kwamfutar ba a cikin saitunan tsarin, taga zai fara, wanda zai sanar da kai cewa ba za a bude fayil ba. Zai bada zabin don aikin:
   • Bincika matches a layi;
   • Zaɓi shirin daga jerin shirye-shiryen shigarwa.

   Tun da an ɗauka cewa an riga an shigar da na'ura mai kwakwalwa Microsoft Excel, za mu motsa sauyawa zuwa matsayi na biyu kuma danna maballin "Ok" a kasan taga.

   

   Idan wannan tsawo ya riga ya hade da wani shirin, amma muna so mu gudanar da shi a Excel, to amma muna aiki kaɗan. Danna maɓallin sunan da maɓallin linzamin dama. Yarda da menu mahallin. Zaɓi matsayi a ciki "Buɗe tare da". Wani jerin zai buɗe. Idan yana da suna "Microsoft Excel", sa'an nan kuma danna kan shi, amma idan ba ka sami irin wannan sunan ba, to, sai ka shiga cikin abu "Zaɓi shirin ...".

   

   Akwai wani zaɓi. Danna maɓallin sunan da maɓallin linzamin dama. A cikin jerin da ya buɗe bayan aikin karshe, zaɓi matsayi "Properties".

   

   A cikin taga mai gudana "Properties" motsa zuwa shafin "Janar"idan an fara kaddamar a wani shafin. Game da saitin "Aikace-aikace" danna maballin "Canji ...".



3. Idan ka zaɓi wani daga cikin zaɓuɓɓuka guda uku, buɗe bude fayil ɗin bude Har ila yau, idan lissafin shirye-shiryen da aka ba da shawarar a ɓangaren sama na taga ya ƙunshi sunan "Microsoft Excel"sa'an nan kuma danna kan shi, in ba haka ba danna maballin ba "Review ..." a kasan taga.



4. A game da aikin karshe a cikin kula da wurin shirin akan kwamfuta, taga yana buɗewa "Bude tare da ..." a cikin hanyar Explorer. A ciki, je zuwa babban fayil wanda ya ƙunshi fayil ɗin farawa na Excel. Adireshin daidai na hanyar zuwa wannan babban fayil ya dogara ne da fasalin Excel wanda kuka shigar, ko kuma a kan version of Microsoft Office. Hanya na gaba ɗaya zai yi kama da wannan:

   C: Fayilolin Shirin Ayyuka na Microsoft Office Office #

   Maimakon halin "#" Ana buƙatar sauya lambar yawan ofishin ofishinku. Saboda haka don Excel 2010 wannan zai zama lambar "14"Kuma daidai hanyar zuwa babban fayil zai yi kama da wannan:

   C: Files Office Office Office Office 14

   Don Excel 2007, lambar za ta kasance "12"don Excel 2013 - "15"don Excel 2016 - "16".

   Saboda haka, matsa zuwa jagoran da ke sama kuma bincika fayil tare da sunan "EXCEL.EXE". Idan tarin taswirar ba ta gudana akan tsarinka, sunansa zai zama kamar "EXCEL". Zaɓi sunan kuma danna maballin. "Bude".



5. Bayan haka, an sake mayar da mu ta atomatik zuwa maɓallin zaɓi na shirin. Wannan lokaci sunan "Microsoft Office" za'a nuna shi daidai a nan. Idan mai amfani yana buƙatar wannan aikace-aikacen ta buɗe takardun DBF koyaushe ta hanyar sau biyu a kan su ta hanyar tsoho, to, kana buƙatar tabbatar da hakan "Yi amfani da shirin da aka zaba don dukkan fayiloli na irin wannan" daraja daraja. Idan kun shirya kawai buɗewar takardar shaidar DBF a Excel, sa'an nan kuma za ku bude wannan nau'in fayiloli a wani shirin, to, a akasin wannan, za'a cire wannan akwati. Bayan duk saitunan da aka sanya, danna kan maballin. "Ok".



6. Bayan haka, za a kaddamar da takardar DBF a Excel, kuma idan mai amfani ya zaɓi wuri mai dacewa a cikin jerin zaɓin shirin, to, fayilolin wannan tsawo za su bude a Excel ta atomatik bayan danna sau biyu a kan su tare da maɓallin linzamin hagu.

Kamar yadda kake gani, buɗe fayilolin DBF a Excel yana da sauki. Amma, abin takaici, yawancin masu amfani da novice suna rikicewa kuma basu san yadda za a yi ba. Alal misali, basu tsammani saita tsarin da ya dace a cikin taga don bude wani takardu ta hanyar dubawa ta Excel. Ko da mawuyacin wahala ga wasu masu amfani shine bude takardun DBF ta hanyar danna maɓallin linzamin hagu sau biyu, tun da haka saboda haka kana buƙatar canza wasu saitunan tsarin ta hanyar zaɓin shirin.