DBF yog ib hom qauv zoo rau kev khaws cia thiab sib pauv cov ntaub ntawv sib txawv ntawm cov kev pab cuam, thiab feem ntau ntawm cov ntawv thov pabcuam databases thiab spreadsheets. Txawm hais tias nws tau ua dhau lawm, nws tseem nyob rau hauv kev thov nyob rau hauv ntau yam teb. Piv txwv li, cov kev pabcuam nyiaj txiag tseem niaj hnub ua haujlwm nrog nws, thiab cov neeg tswjfwm thiab lub xeev cov neeg ua haujlwm tau txais ib feem tseem ceeb ntawm cov ntawv qhia hauv hom ntawv no.
Tab sis, hmoov tsis, Excel, pib nrog version of Excel 2007, nres tag nrho cov nyiaj them yug rau cov hom ntaub ntawv. Tam sim no, hauv qhov kev pab cuam no, koj tsuas saib tau cov ntsiab lus ntawm DBF cov ntaub ntawv, thiab txuag cov ntaub ntawv nrog qhov kev qhia ntxiv uas siv cov cuab yeej built-in ntawm daim ntawv thov lawm. Zoo hmoo, muaj lwm txoj kev rau kev hloov cov ntaub ntawv los ntawm Excel rau hauv hom uas peb xav tau. Xav txog qhov no yuav ua li cas.
Txuag cov ntaub ntawv hauv DBF hom ntawv
Nyob rau hauv Excel 2003 thiab nyob rau hauv versions dhau los ntawm qhov kev kawm no, koj yuav txuag cov ntaub ntawv hauv DBF (dBase) hom nyob rau hauv txoj kev txheem. Ua li no, nyem qhov khoom "Cov Ntaub Ntawv" nyob rau hauv cov ntawv qhia kab rov tav ntawm daim ntawv thov, thiab tom qab ntawd ces hauv daim ntawv teev npe, xaiv qhov chaw "Txuag Raws Li ...". Thaum pib pib qhov rais ntawm daim ntawv nws yuav tsum xaiv lub npe ntawm hom ntawv yam thiab nias rau ntawm lub pob "Txuag".
Tab sis, hmoov tsis, pib nrog lub version ntawm Excel 2007, Microsoft cov tsim tawm tau xav txog dBase rau outdated, thiab niaj hnub Excel tawm tswv yim nyuab dhau los siv sij hawm thiab nyiaj txiag kom txav tag nrho compatibility. Yog li ntawd, hauv Excel, nws tau nyeem DBF cov ntaub ntawv, tab sis kev txhawb nqa kev txuag cov ntaub ntawv nyob rau hauv hom ntawv no siv cov cuab yeej software embedded tau txiav. Txawm li cas los xij, muaj ntau txoj hauv kev hloov cov ntaub ntawv rua hauv Excel rau DBF siv ntxiv-ntxiv thiab lwm yam software.
Txoj kev 1: WhiteTown Converters Pob
Muaj ntau cov kev pab cuam uas cia koj hloov cov ntaub ntawv los ntawm Excel mus rau DBF. Ib qho yooj yim kom hloov cov ntaub ntawv los ntawm Excel mus rau DBF yog siv cov nqi hluav taws xob los hloov cov khoom siv nrog ntau lub extensions mus rau WhiteTown Converters Pob.
Download tau WhiteTown Converters Pob
Txawm hais tias txoj kev teeb tsa ntawm qhov kev qhia no yooj yim thiab intuitive, peb yuav rov tau nyob ntawm nws hauv kev nthuav dav, taw qhia tawm ib co nuances.
- Tom qab koj tau downloaded thiab launched lub installer, lub qhov rais opens tam sim ntawd. Installation Wizardsnyob rau hauv uas nws tau npaj siab los xaiv ib hom lus rau kev txhim kho ntxiv. Yog lub neej ua ke, cov lus ntawm lub xovtooj ntawm koj lub xovtooj yuav tsum tshwm muaj, tabsis koj tuaj yeem hloov tau yog tias koj xav tau. Peb yuav tsis ua qhov no thiab cia li nyem rau ntawm lub pob. "OK".
- Tom ntej no, lub qhov rais qhib rau hauv qhov chaw ntawm qhov system disk yog qhia tias qhov twg yuav tsum tau nruab ib lub chaw tso dej. Yog vim qhov no nws yog ib phau ntawv. "Cov Ntaub Ntawv Cov Ntaub Ntawv" ntawm disk "C". Nws zoo dua tsis hloov dab tsi ntawm no thiab nias ib qhov tseem ceeb "Tom ntej".
- Tom qab ntawd lub qhov rais qhib nyob rau hauv uas koj tuaj yeem xaiv qhov raws nraim qhov kev coj ntawm kev hloov dua siab tshiab koj xav kom muaj. Yog vim li cas, txhua yam muaj peev txheej hloov tau xaiv. Tab sis tej zaum qee cov neeg siv yuav tsis xav nruab lawv txhua tus, raws li txhua lub chaw ua haujlwm siv qhov chaw ntawm lub hard disk. Nyob rau hauv txhua rooj plaub, nws yog ib qho tseem ceeb rau peb tias muaj ib tug zuam nyob ze ntawm lub point "XLS (Excel) rau DBF Converter". Kev txhim kho ntawm cov khoom ntxiv ntawm cov nqi hluav taws xob, tus neeg siv yuav xaiv tau lawv qhov kev pom zoo. Thaum qhov chaw ua tiav, tsis txhob hnov qab nyem rau ntawm tus yuam sij "Tom ntej".
- Tom qab ntawd, lub qhov rais qhib hauv qhov shortcut hauv daim nplaub tshev ntxiv. "Pib". Lub npe ntawm daim ntawv sau npe hu ua "WhiteTown", tab sis koj tuaj yeem hloov nws lub npe yog tias koj xav tau. Peb nias ntawm qhov tseem ceeb "Tom ntej".
- Tom qab ntawd qhib lub qhov rais nug seb puas yuav tsim ib qho shortcut ntawm lub desktop. Yog tias koj xav tau nws ntxiv, tawm ib qho zuam ze rau ntawm qhov ntsuas, yog tias koj tsis xav, ces tshem tawm nws. Tom qab ntawd, raws li ib txwm, nias lub ntsiab "Tom ntej".
- Tom qab ntawd, lwm qhov rais qhib. Nws teev cov txheej txheem tsis tseem ceeb. Yog hais tias tus neeg siv tsis txaus siab rau ib yam dab tsi, thiab nws xav hloov cov tsis, ces koj yuav tsum nias lub khawm "Rov qab". Yog hais tias txhua yam yog nyob rau hauv kev txiav txim, ces nyem rau ntawm lub pob. "Nruab".
- Txoj kev pib kho pib, qhov kev kawm uas yuav tsum tau tawm los ntawm qhov taw qhia dynamic.
- Tom qab ntawd ib qho lus qhia tshwm nyob rau hauv lus Askiv hais txog kev ris txiaj rau kev teeb tsa ntawm pob ntawv no. Peb nias ntawm qhov tseem ceeb "Tom ntej".
- Hauv lub qhov rais kawg Installation Wizards Nws tau tshaj tawm tias qhov kev pab cuam WhiteTown Converters Pob tau txhim kho tau. Peb tsuas tuaj yeem nias lub khawm "Teb".
- Tom qab ntawd, hu ua ib daim nplaub tshev "WhiteTown". Nws muaj cov ntawv teev dej rau tej qhov chaw ntawm kev hloov dua siab tshiab. Qhib daim nplaub tshev. Peb ntsib nrog ntau cov kev pabcuam uas muaj nyob hauv WhiteTown pob hauv ntau qhov chaw ntawm kev hloov dua siab tshiab. Tsis tas li, txhua cov kev taw qhia muaj ib qho kev pabcuam rau 32-ntsis thiab 64-ntsis qhov rais operating systems. Qhib daim ntawv thov nrog lub npe "XLS rau DBF Converter"sib nug xov me ntsis rau koj OS.
- Qhov kev pab pib lub XLS rau DBF Converter. Raws li koj tau pom, lub interface yog lus Askiv, tab sis, cuaj kaum, nws yog intuitive.
Tam sim ntawd qhib lub tab "Tswv yim" ("Sau"). Nws yog npaj los qhia meej txog yam khoom uas yuav hloov dua siab tshiab. Ua li no, nyem rau ntawm lub pob "Ntxiv" ("Ntxiv").
- Tom qab ntawd, tus txheej txheem ntxiv qhov qhib qhov rais qhib. Nyob rau hauv, koj yuav tsum mus rau hauv phau ntawv uas yuav tsum tau ua haujlwm Excel uas muaj xls lossis xlsx txuas ntxiv. Tom qab pom tus kwv, xaiv nws lub npe thiab nias rau ntawm lub pob "Qhib".
- Raws li koj tau pom, tom qab no txoj kev mus rau qhov khoom yuav tshwm rau hauv tab "Tswv yim". Peb nias ntawm qhov tseem ceeb "Tom ntej" ("Tom ntej").
- Tom qab ntawd peb tau tsiv mus rau qhov thib ob. "Tshaj tawm" ("Xaus"). Ntawm no koj yuav tsum qhia meej nyob rau hauv phau ntawv cov khoom tiav nrog DBF ncua ntxiv yuav tshwm. Thiaj li xaiv lub nplaub tshev kom tseg tau DBF cov ntaub ntawv tiav, nias ntawm lub pob "Xauj ..." ("Saib"). Ib daim ntawv teev npe ntawm ob yam khoom qhib. "Xaiv Cov Ntaub Ntawv" ("Xaiv cov ntaub ntawv") thiab "Xaiv qhov sau" ("Xaiv npe"). Qhov tseeb, cov khoom no tsuas qhia qhov kev xaiv ntawm ntau hom navigation qhov rai kom qhia tau tias yog tus nplaub tshev tseg. Kev xaiv.
- Nyob rau hauv rooj plaub thawj zaug, nws yuav yog qhov rais. "Txuag Raws Li ...". Nws yuav tso saib ob folders thiab twb muaj cov khoom dBase lawm. Mus rau ntawm qhov chaw uas peb xav kom tseg. Tom ntej tom teb "Filename" qhia lub npe nyob rau hauv uas peb xav kom cov khoom tshwm tom qab hloov dua siab tshiab. Tom qab ntawd, nyem rau ntawm lub pob "Txuag".
Yog tias koj xaiv "Xaiv qhov sau", ces yuav tsum xaiv qhov kev xaiv qhov rai tshiab yuav qhib. Tsuas yog cov ntawv sau tawm hauv nws. Xaiv lub nplaub tshev kom txuag thiab nias rau ntawm lub pob. "OK".
- Raws li koj tau pom, tom qab ib qho ntawm cov kev ua no, txoj kev mus rau lub nplaub tshev rau txuag cov khoom yuav tshwm rau hauv tab "Tshaj tawm". Mus rau tom ntej tab, nias rau "Tom ntej" ("Tom ntej").
- Nyob rau hauv lub xeem tab "Kev xaiv" ("Kev xaiv") ntau qhov chaw, tab sis peb nyiam tshaj plaws "Hom ntawv memo" ("Memo field type"). Nias rau ntawm thaj chaw uas yog qhov chaw nyob "Pib" ("Pib"). Ib daim ntawv teev cov hom dBase kom txuag tau qhov khoom qhib. Qhov kev ntsuas no tseem ceeb heev, vim tias tsis yog txhua qhov kev pab cuam uas ua haujlwm nrog dBase tau tswj txhua hom khoom nrog qhov kev txuas ntxiv no. Yog li, koj yuav tsum paub ua ntej hom xaiv. Nws muaj kev xaiv li ntawm 6 hom sib txawv:
- dBASE III;
- Foxpro;
- dBASE IV;
- Nrig txog kev pom zoo;
- > SMT;
- dBASE Qib 7.
Peb ua qhov xaiv ntawm hom uas yuav tsum tau siv rau hauv ib qho kev kawm tshwj xeeb.
- Tom qab xaiv tau lawm, koj tuaj yeem mus rau txoj kev hloov dua siab tshiab. Ua li no, nyem rau ntawm lub pob "Pib" ("Pib").
- Txoj kev hloov dua tshiab pib. Yog tias muaj ntau cov ntawv txheeb rau cov phau ntawv Excel, yuav tsum muaj cov ntaub ntawv DBF cais rau txhua tus ntawm lawv. Qhov kev qhia tau qhab nia yuav qhia txog qhov ua tiav ntawm kev hloov txheej txheem. Tom qab nws nce mus txog qhov kawg ntawm lub tiaj, nias ntawm lub pob "Suav" ("Suav").
Cov ntaub ntawv tiav yuav tsum tau nyob hauv phau ntawv teev npe uas tau muab teev rau hauv tab "Tshaj tawm".
Qhov teeb meem tseem ceeb ntawm kev siv pob WhiteTown Converters Pack pob yog tias tsuas yog 30 txoj kev hloov dua tshiab thiaj ua tau dawb, ces koj yuav tsum tau yuav daim ntawv tso cai.
Txoj kev 2: XlsToDBF Ntxiv-hauv
Koj tuaj yeem hloov phau ntawv Excel rau dBase ncaj nraim los ntawm daim ntawv thov kev nruab nrab ntawm kev txhim kho sab nraud ntxiv. Ib qho zoo tshaj plaws thiab yooj yim tshaj ntawm lawv yog cov XlsToDBF ntxiv. Xav txog qhov algorithm ntawm nws daim ntawv thov.
Download Add-on XlsToDBF
- Tom qab lub XlsToDBF.7z archive nrog tus ntxiv-tau raug downloaded, unpack tus kwv hu ua XlsToDBF.xla los ntawm nws. Vim tias cov ntaub ntawv muaj kev sib txuas ntawm 7z, kev tsim tawm yuav ua tau los ntawm qhov txheej txheem kev tsim kho rau 7-Zip txuas ntxiv, los yog nrog kev pab ntawm lwm tus neeg saib xyuas uas txhawb nws.
- Tom qab ntawd, khiav Excel program thiab mus rau lub tab "Cov Ntaub Ntawv". Tom qab, txav mus rau seem "Kev xaiv" los ntawm cov zaub mov ntawm sab laug ntawm lub qhov rais.
- Hauv qhov ntsuas qhov tsis tau qhib, nyem rau ntawm qhov khoom Ntxiv-ons. Tsiv mus rau sab xis ntawm lub qhov rais. Nyob rau hauv nws heev hauv qab yog ib daim teb. "Kev Tswj". Rearrange tus tes hloov qhov chaw Excel Ntxiv-ins thiab nyem rau ntawm lub pob "Mus ...".
- Qhib me me tswj kev lag luam ntxiv. Peb nias rau hauv khawm "Ntsuam xyuas ...".
- Cov khoom qhib qhov rai pib. Peb yuav tsum tau mus rau ntawm qhov chaw uas muaj cov xlspace XlsToDBF nyob rau hauv. Mus rau hauv daim nplaub tshev hauv tib lub npe thiab xaiv cov khoom nrog lub npe "XlsToDBF.xla". Tom qab ntawd, nyem rau ntawm lub pob "OK".
- Tom qab ntawd peb rov qab mus rau qhov kev tiv thaiv lub qhov rais ntxiv. Raws li koj tau pom, lub npe nyob hauv daim ntawv teev npe. "XLS -> DBF". Nov yog peb qhov ntxiv. Yuav tsum muaj tus zuam ze nws. Yog tias tsis muaj tus cim kos, ces muab tso rau, ces nyem rau ntawm lub pob "OK".
- Yog li, tus ntxiv-yog nruab. Tam sim no qhib Excel ntawv, cov ntaub ntawv los ntawm qhov uas koj xav siv hloov mus rau dBase, los yog ntaus lawv ntawm daim ntawv yog tias tsis tau muab cov ntaub ntawv tseem tsis tau tsim.
- Tam sim no peb yuav tsum tau ua qee cov ntaub ntawv ntxias kom thiaj li npaj tau lawv rau kev hloov dua siab tshiab. Ua ntej tshaj, peb ntxiv ob txoj kab saum toj rooj saum rooj. Lawv yuav tsum yog thawj zaug ntawm daim ntawv thiab muaj cov npe ntawm qhov chaw tswj hwm ntawm lub viav vias "1" thiab "2".
Nyob rau saum toj kawg nkaus ntawm tes, sau lub npe uas peb xav muab cob rau DBF cov ntaub ntawv tsim. Nws muaj ob qho: qhov tseeb lub npe thiab kev txuas ntxiv. Tsuas yog Latin cim xwb. Ib qho piv txwv ntawm xws li lub npe yog "UCHASTOK.DBF".
- Nyob hauv thawj lub xov tooj ntawm sab xis ntawm txoj cai ntawm lub npe koj yuav tsum qhia kom meej rau qhov cim lus. Muaj ob qho kev xaiv rau kev siv qhov kev sib ntxiv ntawm no: CP866 thiab CP1251. Yog tias ntawm tes B2 npliag los yog nws yog teem rau tej nqi uas tsis yog "CP866", yuav siv cov cim coding default CP1251. Peb muab cov lus nug uas peb xav tau los yog tawm ntawm qhov chaw khoob.
- Ntxiv mus, mus rau kab tom ntej. Qhov tseeb yog tias hauv cov qauv dBase, txhua kem, hu ua teb, nws muaj nws cov ntaub ntawv. Muaj xws li cov lus qhia:
- N (Numeric) - numeric;
- L (Cov zajlus) - zaj tswv yim;
- D (Hnub tim) - hnub tim;
- C (Tsa) - txoj hlua.
Kuj tseem nyob hauv txoj hlua (Cnnn) thiab numeric hom (Nnn) tom qab lub npe nyob rau hauv daim ntawv ntawm ib tsab ntawv yuav tsum tau qhia txog qhov siab tshaj plaws ntawm cov cim hauv lub tshav. Yog tias cov zauv cim ua zauv yog siv hom zauv, lawv cov zauv kuj yuav tsum tau qhia rau tom qab ntawd (Nnn.n).
Muaj lwm hom ntaub ntawv nyob rau hauv hom dBase (Memo, General, etc.), tab sis qhov no ntxiv tsis tuaj yeem ua haujlwm nrog lawv. Txawm li cas los, Excel 2003 tsis paub yuav ua li cas nrog lawv, thaum nws tseem txhawb kev hloov siab los ntseeg rau DBF.
Hauv peb cov ntaub ntawv, thawj teb yuav yog ib txoj hlua 100 cim dav (C100), thiab cov seem ntxiv yuav yog numeric 10 cim dav (N10).
- Cov kab tom ntej no muaj cov npe ntawm thaj chaw. Tab sis qhov tseeb yog hais tias lawv yuav tsum tau nkag mus rau hauv Latin, thiab tsis nyob hauv Cyrillic, raws li peb ua. Tsis tas li ntawd, tsis muaj qhov chaw nyob hauv cov npe cov npe. Ntaus lawv raws li cov cai no.
- Tom qab no, cov ntaub ntawv npaj yuav suav tau tias ua tiav. Xaiv tus cursor rau ntawm daim ntawv nrog cov laug nas khawm tuav tag nrho ntawm lub rooj. Ces mus rau lub tab "Tsim tawm". Nws yog neeg xiam los ntawm lub neej ua ntej, yog li ua ntej ntxiv manipulations koj yuav tsum qhib nws thiab pab kom macros. Tom ntej no rau ntawm txoj hlua rau hauv lub thawv ntawv "Txoj Cai" nyem rau ntawm lub cim Macros.
Koj tuaj yeem ua tau yooj yim dua los ntawm kev sau ua ke ntawm cov kub tuav Alt + F8.
- Khiav macro qhov rais. Hauv teb "Lub npe hu ua" peb sau lub npe ntawm peb cov superstructure "XlsToDBF" tsis muaj quotes. Sau npe tsis tseem ceeb. Tom ntej no, nias lub khawm Khiav mus.
- Lub macro nyob tom qab ua tiav. Tom qab ntawd, nyob rau tib phau ntawv qhov chaw Excel qhov chaw nyob, tus kwv nrog lub DBF yuav ntxiv nrog lub npe teev hauv xov tooj ntawm tes A1.
Download tau 7-Zauv teb dawb
Raws li koj tau pom, qhov no yog qhov teeb meem ntau tshaj li qhov yav dhau los. Tsis tas li ntawd, nws tsawg heev ntawm cov hom siv hom thiab tsim hom khoom nrog Extension DBF. Lwm disadvantage yog tias dBase kwv creation directory yuav ua rau tsuas ua ntej txoj kev hloov dua siab tshiab, los ntawm kev ncaj qha mus rau cov cag lus siv ntawm Excel qhov chaw. Ntawm qhov zoo ntawm cov qauv no, nws yuav tsum tau sau tseg tias, tsis zoo li yav dhau los, nws yog kiag li dawb thiab yuav luag txhua tus txiv neej tau ua ncaj qha los ntawm Excel interface.
Method 3: Siv Microsoft Access
Txawm hais tias tus tshiab versions of Excel tsis muaj ib qho built-in los cawm cov ntaub ntawv hauv DBF hom, tab sis txawm li cas los, qhov kev xaiv uas siv Microsoft Access yog qhov ze tshaj plaws los hu nws tus qauv. Qhov tseeb yog tias qhov kev pabcuam no yog tso tawm los ntawm tib lub chaw tsim khoom li Excel, thiab kuj muaj nyob hauv Microsoft Office lub pob. Ntxiv mus, nws yog qhov kev nyab xeeb tshaj plaws, vim nws tsis tas yuav hu rau lwm tus neeg software. Microsoft Access yog tsim los ua haujlwm nrog databases.
Download tau Microsoft Access
- Tom qab tag nrho cov ntaub ntawv tsim nyog rau ntawm daim ntawv hauv Excel nkag, kom hloov tau lawv mus rau hom ntawv DBF, koj yuav tsum xub sau tseg rau ib hom ntawm Excel. Ua li no, nyem rau ntawm daim duab nyob rau hauv daim ntawv ntawm lub tshuab floppy nyob rau sab qaum sab laug ntawm qhov kev pab cuam qhov rai.
- Ib qho qhib qhov rais qhib. Mus rau ntawm qhov chaw uas peb xav tau cov ntaub ntawv kom tau txais kev cawmdim. Nws yog los ntawm daim nplaub tshev uas koj yuav tau qhib nws tom qab ntawm Microsoft Access. Cov hom ntawv ntawm phau ntawv yuav tseg tau los ntawm default xlsx, thiab hloov tau mus rau xls. Hauv qhov no, qhov no tsis yog qhov tseem ceeb, vim peb tseem khaws cov ntaub ntawv kom hloov mus rau DBF. Tom qab tag nrho cov chaw ua tiav, nias ntawm lub pob. "Txuag" thiab kaw qhov rais Excel.
- Khiav ntawm qhov kev zov me nyuam Microsoft Access. Mus rau lub tab "Cov Ntaub Ntawv"yog tias nws qhib hauv lwm tab. Nias rau ntawm daim ntawv qhia zaub mov "Qhib"nyob rau sab laug ntawm lub qhov rais.
- Lub pib qhib qhov rai pib. Mus rau ntawm qhov chaw uas peb tau txais kev cawmdim rau hauv cov ntaub ntawv hauv Excel. Mus tso saib nyob rau hauv lub qhov rais, rearrange cov ntaub ntawv hom hloov mus "Excel workbook (* .xlsx)" los yog "Microsoft Excel (* .xls)", nyob ntawm seb ntawm lawv phau ntawv tau txais kev cawmdim. Tom qab lub npe ntawm cov ntaub ntawv peb xav tau tso tawm, xaiv nws thiab nyem rau ntawm lub pob "Qhib".
- Qhov rais qhib "Txuas mus rau Spreadsheet". Nws tso cai rau koj hloov cov ntaub ntawv los ntawm Excel rau Microsoft Access kom meej li tseeb tau. Peb yuav tsum xaiv cov ntawv Excel, cov ntaub ntawv uas peb yuav tsum tau import. Qhov tseeb yog tias txawm tias Excel cov ntaub ntawv muaj cov ntaub ntawv rau ntau cov ntawv txheeb, ces koj tuaj yeem nkag mus rau hauv Txais Cov Kev Sib Txawv xwb, raws li, ces hloov mus rau cov ntaub ntawv DBF cais.
Nws tseem tuaj yeem tuaj yeem tuaj qhia cov ntaub ntawv los ntawm cov neeg nyob rau hauv cov ntawv txheeb. Tab sis nyob rau hauv peb cov ntaub ntawv nws tsis yog tsim nyog. Teem tus tes hloov mus rau txoj haujlwm "Cov ntawv txheeb", thiab tom qab ntawd xaiv cov ntawv uas peb yuav siv cov ntaub ntawv. Qhov tseeb ntawm cov ntaub ntawv ntawm cov ntaub ntawv tuaj yeem pom hauv qab ntawm qhov rais. Yog tias txhua yam ua tiav, nyem rau ntawm lub pob. "Tom ntej".
- Hauv qhov rais ntxiv, yog tias koj cov lus muaj cov npe, koj yuav tsum khij lub npov "Thawj kab leej twg muaj sab taub hau". Ces nyem rau ntawm lub pob "Tom ntej".
- Nyob rau hauv qhov txuas tshiab rau ntawm lub vev xaib qhov rai, koj tuaj yeem xaiv tau lub npe ntawm cov khoom txuas. Ces nyem rau ntawm lub pob "Ua li cas".
- Tom qab qhov no, qhib lub thawv qhib tawm uas yuav muaj lus hais tias qhov sib txuas ntawm lub rooj nrog Excel cov ntaub ntawv tiav. Peb nias lub khawm "OK".
- Lub npe ntawm lub rooj, uas peb muab rau nws nyob rau hauv lub qhov rais kawg, yuav tshwm rau sab laug ntawm lub program interface. Ob npaug nias rau ntawm sab laug nas khawm.
- Tom qab ntawd, lub rooj qhia tawm hauv lub qhov rais. Txav mus rau tab "Cov ntaub ntawv sab nraud".
- Rau daim kab xev hauv lub nras cov cuab yeej "Export" nyem rau ntawm daim ntawv lo "Qib Siab". Nyob rau hauv cov npe uas tau qhib, xaiv qhov khoom "Cov ntaub ntawv DBase".
- Tus xa tawm rau DBF hom lub qhov rais qhib. Hauv teb "Filename" Koj tuaj yeem qhia meej txog cov ntaub ntawv cia thiab qhov nws lub npe, yog cov uas tau hais los ntawm lub neej tsis haum rau koj vim qee yam.
Hauv teb "Ua Ntawv Thov" Xaiv ib hom peb hom DBF hom:
- dBASE III (vim);
- dBASE IV;
- dBASE 5.
Nws yog tsim nyog yuav tsum tau coj mus rau hauv tus account tias ntau niaj hnub hom (lub siab dua yog cov naj npawb sib lawv liag), qhov ntau lub sij hawm muaj rau kev ua cov ntaub ntawv hauv nws. Ntawd yog, muaj qhov tshwmsim siab tshaj tias tag nrho cov ntaub ntawv hauv lub rooj yuav raug cawm hauv cov ntaub ntawv. Tab sis tib lub sij hawm, qhov tshwm sim rau qhov kev zov me nyuam uas koj yuav tau xa cov ntaub ntawv DBF yav tom ntej yuav tau tshaj qhov no yog qhov tsawg dua.
Tom qab tag nrho cov chaw teev, nyem rau ntawm lub pob "OK".
- Yog hais tias muaj lus yuam kev tom qab ntawd, sim tawm cov ntaub ntawv uas siv hom DBF ntau hom. Yog hais tias txhua yam mus zoo, lub qhov rais yuav tshwm sim, qhia koj tias tus export yog zoo. Peb nias lub khawm "Kaw".
Cov ntaub ntawv tsim hauv dBase hom yuav tau nyob hauv cov npe uas tau teev nyob rau hauv lub qhov rais export.Tom qab ntawd koj tuaj yeem ua haujlwm nrog nws, nrog rau kev xa mus rau lwm cov kev pabcuam.
Raws li koj pom, txawm tias qhov tseeb uas niaj hnub no ntawm Excel tsis muaj peev xwm txuag tau cov ntaub ntawv hauv DBF hom nrog built-in cov cuab yeej, txawm li cas los xij, cov txheej txheem no yuav raug siv tawm nrog lwm cov kev pabcuam thiab ntxiv-rau. Nws yuav tsum tau sau tseg tias txoj kev hloov siab tshaj plaws yog siv cov WhiteTown Converters Pack vam. Tab sis, hmoov tsis, cov xov tooj ntawm cov neeg tuaj yeem dawb hauv nws yog tsawg. Lub XlsToDBF ntxiv-tso cai rau koj kom hloov siab los ntseeg kiag li dawb, tab sis cov txheej txheem yog ntau yam nyuab dua. Tsis tas li, cov kev ua haujlwm ntawm qhov kev xaiv no tsawg heev.
Qhov "Golden txhais" yog ib txoj kev uas siv cov kev pabcuam Saib. Zoo li Excel, qhov no yog txoj kev loj hlob los ntawm Microsoft, thiab yog li koj tsis tuaj yeem hu rau nws daim ntawv thov thib peb. Ntxiv mus, qhov kev xaiv no tso cai rau koj hloov cov ntaub ntawv Excel ua ntau hom dBase. Txawm hais tias nyob rau hauv qhov ntsuas no nws tseem tsis tau zoo dua rau WhiteTown.