YUAV UA LI CAS HLOOV EXCEL RAU DBF

Send

DBF yog cov qauv nrov rau khaws cia thiab sib pauv cov ntaub ntawv ntawm ntau cov kev pabcuam, thiab feem ntau ntawm cov ntawv thov uas pabcuam rau databases thiab spreadsheets. Txawm hais tias nws tau dhau los ua dhau los, nws tseem muaj kev xav tau nyob hauv ntau daim teb. Piv txwv, cov kev zov me nyuam mus txuas ntxiv ua haujlwm nrog nws, thiab cov cai thiab lub xeev lub cev lees txais ib feem tseem ceeb ntawm cov ntawv qhia hauv hom ntawv no.

Tab sis, hmoov tsis zoo, Excel, pib nrog version ntawm Excel 2007, tau tso tseg tag nrho cov kev txhawb nqa rau hom ntawv no. Tam sim no nyob rau hauv cov kev pab cuam no koj tsuas saib tau cov ntsiab lus ntawm DBF cov ntaub ntawv, thiab txuag cov ntaub ntawv nrog cov txuas ntxiv teev siv daim ntawv thov cov cuab yeej tsim tawm yuav poob. Qhov zoo, muaj lwm txoj hauv kev rau hloov cov ntaub ntawv los ntawm Excel rau hom ntawv uas peb xav tau. Xav txog qhov no yuav ua li cas.

Txuag cov ntaub ntawv nyob rau hauv DBF hom

Hauv Excel 2003 thiab hauv cov khoos kas ua ntej, nws tau txuag cov ntaub ntawv hauv DBF (dBase) hauv kev ua tus qauv. Ua li no, nyem rau ntawm qhov khoom Cov ntaub ntawv hauv kab ntawv kab rov tav ntawm daim ntawv thov, thiab tom qab ntawd hauv cov npe uas qhib, xaiv qhov chaw "Tseg Raws Li ..."Cov. Hauv kev txuag nyiaj uas tau pib, nws yuav tsum xaiv lub npe ntawm cov ntawv uas yuav tsum tau los ntawm daim ntawv thiab nyem rau ntawm lub pob Txuag.

Tab sis, hmoov tsis zoo, pib nrog version ntawm Excel 2007, Microsoft cov neeg tsim khoom suav hais tias dBase yuav tsum tsis tsim nyog, thiab Excel cov qauv niaj hnub no nyuaj dhau los siv sijhawm thiab nyiaj txiag los ntawm kev ua kom muaj kev sib koom ua ke tag nrho. Yog li no, Excel tseem tuaj yeem nyeem DBF cov ntaub ntawv, tab sis kev txhawb nqa kom txuag tau cov ntaub ntawv hauv hom ntawv no nrog cov cuab yeej software tsim nrog raug txiav. Txawm li cas los xij, muaj qee txoj hauv kev los hloov cov ntaub ntawv khaws cia hauv Excel rau DBF siv cov tshuaj ntxiv thiab lwm yam software.

Txoj Kev 1: WhiteTown Converters Pob

Muaj ntau tus txheej txheem uas tso cai rau koj los hloov cov ntaub ntawv los ntawm Excel rau DBF. Ib txoj hauv kev yooj yim tshaj plaws los hloov cov ntaub ntawv los ntawm Excel rau DBF yog siv pob khoom siv hluav taws xob los hloov cov khoom siv nrog rau ntau yam WhiteTown Converters Pob txuas ntxiv.

Download Dawb Pob Tawb Hloov Pauv

Txawm hais tias cov txheej txheem kev teeb tsa rau cov program no yooj yim thiab xav paub, txawm li ntawd los peb yuav nyob ntawm nws hauv kev nthuav dav, taw tes qee qhov nuances.

Tom qab koj rub tawm thiab khiav lub installer, lub qhov rai qhib tam sim Installation wizardsnyob rau hauv uas nws tau npaj siab los xaiv lus rau cov txheej txheem kev teeb tsa ntxiv. Los ntawm lub neej ntawd, cov lus uas tau ntsia rau hauv koj lub Windows piv txwv yuav tsum tau muab tso tawm rau ntawd, tab sis koj tuaj yeem hloov nws yog tias koj xav tau. Peb yuav tsis ua qhov no thiab nyem rau ntawm lub pob "OK".

Tom ntej no, lub qhov rais tawm nyob rau hauv uas qhov chaw ntawm lub system disk qhov twg cov nqi hluav taws xob yuav raug teeb tsa. Nov yog kev qhia ua ntej. "Cov Ntaub Ntawv Cov Ntaub Ntawv" ntawm disk "C"Cov. Nws zoo dua tsis txhob hloov ib qho twg thiab nias tus yuam sij "Tom ntej".

Tom qab ntawd lub qhov rais qhib uas koj tuaj yeem xaiv raws nraim qhov kev qhia hloov dua siab tshiab uas koj xav tau. Los ntawm lub neej ntawd, txhua cov sib pauv hloov pauv tau xaiv. Tab sis, tej zaum, qee tus neeg siv yuav tsis xav nruab lawv txhua tus, txij li txhua tus nqi hluav taws xob coj mus rau qhov chaw ntawm lub hard drive. Nyob rau hauv txhua rooj plaub, nws yog qhov tseem ceeb rau peb uas yuav tsum muaj qhov khij nyob ntawm cov khoom "XLS (Excel) rau DBF Hloov"Cov. Tus neeg siv yuav xaiv tau qhov teeb tsa ntawm cov khoom sib txuas ntxiv ntawm cov khoom siv pob ntawm nws kev txiav txim siab. Tom qab kev teeb tsa tiav, tsis txhob hnov qab nias lub khawm "Tom ntej".

Tom qab ntawd, lub qhov rais qhib nyob rau hauv uas ib qho kev qhia txuas ntxiv rau hauv daim nplaub tshev PibCov. Los ntawm lub neej ntawd, txoj kab ke hu ua "DawbTown", tab sis yog xav tau, koj tuaj yeem hloov nws lub npe. Nyem rau qhov tseem ceeb "Tom ntej".

Tom qab ntawd lub qhov rais tau tsim tawm nug seb puas yuav tsim ib qho kev xaiv ntawm lub desktop. Yog tias koj xav tau nws yuav ntxiv, tom qab ntawd tawm ib qho khij ntawm ib sab parameter, yog tias koj tsis xav, rho tawm nws. Tom qab ntawd, raws li ib txwm, nias tus yuam sij "Tom ntej".

Tom qab ntawd, lwm lub qhov rais qhib. Nws qhia qhov yooj yim xaiv teeb tsa. Yog tias tus neeg siv tsis zoo siab nrog ib yam dab tsi, thiab nws xav kho cov ciaj ciam, ces nias lub pob "Rov Qab"Cov. Yog tias txhua yam nyob hauv kev txiav txim, ces nyem rau khawm Nruab.

Cov txheej txheem kev teeb tsa pib, qhov kev nce qib ntawm uas yuav pom los ntawm cov taw qhia muaj zog.

Tom qab ntawd cov ntaub ntawv xov xwm yuav qhib ua lus Askiv, nyob rau hauv uas kev ris txiaj yog qhia rau kev teeb tsa ntawm pob ntawv no. Nyem rau qhov tseem ceeb "Tom ntej".

Nyob rau hauv lub qhov rai kawg Installation wizards nws tau tshaj tawm tias WhiteTown Converters Pob tau tiav cov teeb meem. Peb tsuas tuaj yeem nyem lub pob Xaus.

Tom qab ntawv, ib qho hu ua "DawbTown"Cov. Nws muaj cov nqi hluav taws xob luv rau qee thaj tsam ntawm kev hloov dua siab tshiab. Qhib daim nplaub tshev no. Peb muaj kev cuam tshuam nrog ntau ntawm cov kev siv nyiaj tso nrog rau hauv WhiteTown pob hauv ntau qhov chaw ntawm kev hloov dua siab tshiab. Tib lub sijhawm, txhua qhov kev taw qhia nyias muaj nyias cov nqi sib txawv rau 32-ntsis thiab 64-ntsis Windows ua haujlwm. Qhib daim ntawv thov nrog lub npe "XLS rau DBF Hloov"sib nug mus rau qhov tob me ntsis ntawm koj OS.

Txoj haujlwm XLS rau DBF Hloov pib. Raws li koj tuaj yeem pom, lub interface yog hais lus Askiv, tab sis, txawm li ntawd los, nws yog qhov paub tau.
Lub tab qhib tam sim ntawd "Cov tswv yim" (Sau) Nws yog los qhia qhov khoom yuav tsum hloov pauv. Ua li no, nyem rau ntawm pob nyem "Ntxiv" (Ntxiv).

Tom qab ntawd, cov txheej txheem qhov rai rau ntxiv ib qho khoom siv qhib. Hauv nws, koj yuav tsum tau mus rau phau ntawv teev lus uas Excel phau ntawv ua haujlwm peb xav tau yog nyob nrog qhov txuas xls lossis xlsx. Tom qab cov khoom tau pom, xaiv nws lub npe thiab nyem rau ntawm lub pob "Qhib".

Raws li koj tuaj yeem pom, tom qab ntawd txoj kev mus rau qhov khoom tau tshwm rau hauv lub tab "Cov tswv yim"Cov. Nyem rau qhov tseem ceeb "Tom ntej" ("Tom ntej").

Tom qab ntawd, peb cia li tsiv mus rau lub tab thib ob "Tawm Tshiab" ("Xaus lus") Ntawm no koj yuav tsum tau qhia meej nyob rau hauv cov ntawv qhia twg khoom tiav nrog DBF txuas ntxiv yuav tshwm. Txhawm rau xaiv cov ntawv khaws tseg rau ntawv DBF ntawv tiav, nyem rau ntawm lub pob "Xauj ..." (Saib) Cov npe me ntawm ob yam khoom qhib. "Xaiv Cov Ntaub Ntawv" ("Xaiv ntawv") thiab "Xaiv nplaub tshev" ("Xaiv nplaub tshev") Qhov tseeb, cov khoom no tsuas yog txhais tau tias xaiv tau ntau hom navigation lub qhov rais kom paub meej khaws ntawv khaws cia. Peb muaj kev xaiv.

Hauv thawj kis, nws yuav yog lub qhov rais qub "Tseg Raws Li ..."Cov. Nws yuav pom ob qho nplaub tshev thiab cov dBase uas twb muaj lawm. Mus rau hauv phau ntawv teev npe uas peb xav cawm. Ntxiv nyob rau hauv lub teb "Cov ntaub ntawv npe" taw qhia lub npe nyob rau hauv uas peb xav kom tus kwv yuav tsum tau teev tom qab hloov dua siab tshiab. Tom qab ntawv, nyem rau ntawm lub pob Txuag.
Yog koj xaiv "Xaiv nplaub tshev", qhov yooj yim ntawm phau ntawv xaiv lub qhov rai yuav qhib. Tsuas yog cov kab ntawv yuav tshwm rau hauv nws. Xaiv lub nplaub tshev kom txuag thiab nyem rau ntawm lub pob "OK".

Raws li koj tuaj yeem pom, tom qab ib qho ntawm cov yeeb yam no, txoj hauv kev mus rau daim nplaub tshev rau kev txuag cov khoom yuav tau tshwm hauv lub tab "Tawm Tshiab"Cov. Txhawm rau mus rau lwm nqe, nias lub pob no. "Tom ntej" ("Tom ntej").

Nyob rau sab kawg nkaus "Xaiv" ("Xaiv") ntau qhov chaw, tab sis peb txaus siab xav tshaj plaws "Hom memo daim teb" ("Memo teb yam") Peb nyem rau ntawm daim teb uas qhov chaw pib ua "Pib" ("Pib") Daim ntawv teev cov hom dBase qhib kom txuag lub hom. Qhov ntsuas no tseem ceeb heev, vim tias tsis yog txhua cov haujlwm ua haujlwm nrog dBase tuaj yeem coj tau txhua hom khoom nrog qhov txuas ntxiv no. Yog li, koj yuav tsum paub ua ntej tias yuav xaiv hom twg. Muaj rau ntau hom rau xaiv los ntawm:
- dBASE III;
- Quav;
- dBASE IV;
- Siv nrig saib foxpro;
- > SMT;
- dBASE Qib 7.
Peb ua txoj kev xaiv cov hom uas xav tau siv rau hauv cov haujlwm tshwj xeeb.

Tom qab xaiv tiav lawm, koj tuaj yeem mus rau txheej txheem hloov mus ncaj qha. Ua li no, nyem rau ntawm pob nyem "Pib" ("Pib").

Txheej txheem hloov dua siab tshiab pib. Yog tias phau ntawv Excel muaj ob peb cov ntaub ntawv, yuav muaj cov ntawv DBF cais rau lawv. Qhov ntsuas kev txhim kho ntsuab yuav qhia kev ua tiav ntawm kev hloov pauv. Tom qab nws ncav rau qhov kawg ntawm lub tiaj, nyem rau ntawm lub pob "Ua tiav" ("Ua tiav").

Daim ntawv ua tiav tiav yuav nyob rau hauv cov ntawv qhia chaw hauv lub tab "Tawm Tshiab".

Qhov teeb meem tseem ceeb ntawm txoj kev siv WhiteTown Converters Pob hlauv taws xob tau siv yog tias nws yuav muaj peev xwm nqa tau tsuas yog 30 cov txheej txheem hloov pauv dawb, thiab tom qab ntawd koj yuav tsum yuav daim ntawv tso cai.

Txoj Kev 2: XlsToDBF Ntxiv-hauv

Koj tuaj yeem hloov Excel cov phau ntawv mus rau dBase ncaj qha los ntawm daim ntawv thov interface los txhim kho cov ntawv thib peb cov sab nrauv. Ib qhov zoo tshaj plaws thiab yooj yim tshaj plaws ntawm lawv yog XlsToDBF ntxiv-hauv. Xav txog qhov algorithm rau nws daim ntawv thov.

Tso XlsToDBF Ntxiv-hauv

Tom qab rub tawm XlsToDBF.7z archive nrog qhov ntxiv, peb rho tawm ntawm nws ib qho khoom hu ua XlsToDBF.xla. Txij li cov ntawv pov ntawv tau txuas ntxiv mus 7z, tsis tsim kev tuaj yeem tuaj yeem ua nrog nrog cov qauv txheej txheem rau qhov kev txuas ntxiv no 7-Zip, lossis nrog kev pab ntawm lwm lub chaw khaws ntaub ntawv uas txhawb nqa ua haujlwm nrog nws.

Download tau 7-Zip dawb

Tom qab ntawv, khiav ntawm Excel program thiab mus rau ntawm lub tab Cov ntaub ntawvCov. Tom ntej no peb tsiv mus rau ntu "Xaiv" los ntawm cov ntawv qhia zaub mov nyob rau sab laug ntawm lub qhov rais.

Hauv qhov rai uas qhib, nyem rau ntawm qhov khoom "Ntxiv-ons"Cov. Peb tsiv mus rau sab xis ntawm lub qhov rais. Thaum kawg ntawm lub tshav pob yog daim teb "Kev tswj hwm"Cov. Peb rov faib tus tes hloov qhov hauv nws Excel Ntxiv-Ins thiab nias rau pob "Mus ...".

Lub qhov rais me me rau kev tswj hwm cov add-ons qhib. Nyem rau ntawm lub pob hauv nws "Ntsuam xyuas ...".

Lub qhov rais rau kev qhib qhov khoom pib. Peb yuav tsum tau mus rau hauv phau ntawv sau npe qhov chaw uas tsis tau sau cia XlsToDBF archive. Peb mus rau hauv daim nplaub tshev nyob hauv tib lub npe thiab xaiv cov khoom nrog lub npe "XlsToDBF.xla"Cov. Tom qab ntawv, nyem rau ntawm lub pob "OK".

Tom qab ntawd peb rov qab mus rau qhov kev tswj xyuas qhov rai ntxiv. Raws li koj tuaj yeem pom, lub npe tau tshwm sim hauv cov npe "Xls -> dbf"Cov. Nov yog peb ntxiv-ntxiv. Ib zuam yuav tsum nyob ze nws. Yog tias tsis muaj lub cim khij, tom qab ntawd muab tso rau, thiab tom qab ntawv nyem khawm "OK".

Yog li, qhov ntxiv-txuas yog ntsia. Tam sim no qhib Excel ntawv, cov ntaub ntawv los ntawm qhov koj yuav tsum hloov mus rau dBase, lossis tsuas yog ntaus lawv ntawm nplooj ntawv yog tias daim ntawv tseem tsis tau tsim.

Tam sim no peb yuav xav tau qee cov kev ntxias nrog cov ntaub ntawv thiaj li yuav npaj lawv rau kev hloov dua siab tshiab. Ua ntej tshaj plaws, ntxiv ob kab sab saum toj lub rooj header. Lawv yuav tsum yog thawj zaug ntawm daim ntawv thiab muaj npe ntawm cov vaj huam sib luag ntsug "1" thiab "2".
Nyob rau sab saum toj sab laug ntawm tes, sau lub npe uas peb xav kom cob rau DBF cov ntaub ntawv tsim. Nws muaj ob ntu: lub npe nws tus kheej thiab txuas ntxiv. Tsuas pub cov ntawv Latin raug tso cai. Ib qho piv txwv ntawm lub npe zoo li no yog "UCHASTOK.DBF".

Hauv thawj ntawm tes rau sab xis ntawm lub npe koj yuav tsum qhia lub cim kho. Muaj ob qho kev xaiv encoding siv cov add-in: CP866 thiab CP1251Cov. Yog tias ntawm tes B2 khoob los yog lwm tus nqi tshaj li "CP866", tom qab ntawv lub encoding yuav siv los ntawm lub neej ntawd CP1251Cov. Peb muab lub voos xwm txheej uas peb xav tias tsim nyog lossis tawm hauv lub tiaj.

Tom ntej no, mus rau kab tom ntej. Qhov tseeb yog tias nyob hauv dBase cov qauv, txhua kab ntawv, hu ua ib lub teb, nws muaj nws tus kheej cov ntaub ntawv hom. Muaj cov qauv zoo li no:
- N (Tooj) - muaj lej;
- L (Logical) - muaj kuab;
- D (Hnub Tim) - hnub tim;
- C (Cwj pwm) - txoj hlua.
Tsis tas li ntawd nyob rau hauv txoj hlua (Cnnn) thiab naj npawb hom (Nnn) tom qab lub npe nyob rau hauv daim ntawv ntawm tsab ntawv, qhov ntau tshaj plaws ntawm lub cim nyob rau hauv lub teb yuav tsum qhia. Yog hais tias tus lej zauv yog siv hauv tus lej hom, lawv tus lej yuav tsum raug qhia tom qab teev (Nnn.n).
Muaj lwm cov ntaub ntawv nyob rau hauv dBase hom ntawv (Memo, General, thiab lwm yam), tab sis qhov add-in no tsis paub yuav ua haujlwm nrog lawv li cas. Txawm li cas los xij, Excel 2003 tsis paub yuav ua haujlwm nrog lawv li cas, thaum nws tseem txhawb kev hloov dua siab tshiab rau DBF.
Hauv peb qhov xwm txheej tshwj xeeb, thawj daim teb yuav yog txoj hlua dav txog 100 cim (C100), thiab teb ntxiv yuav muaj 10 tus lej dav (N10).

Cov kab tom ntej no suav cov npe teb. Tab sis qhov tseeb yog tias lawv tseem yuav tsum tau nkag rau hauv Latin, thiab tsis nyob hauv Cyrillic, raws li peb muaj. Tsis tas li, qhov chaw tsis pub hauv lub npe cov npe. Pauv lawv raws li cov cai no.

Tom qab ntawd, kev npaj cov ntaub ntawv tuaj yeem suav ua tiav. Xaiv tag nrho cov kab ntawm lub rooj ntawm daim ntawv nrog tus cursor thaum tuav tus nas laug khawm. Tom qab ntawd mus rau hauv lub tab "Tus tsim tawm"Cov. Los ntawm lub neej ntawd, nws yog neeg xiam, yog li ua ntej ntxiv kev siv koj yuav tsum tau ua kom nws thiab ua kom macros. Ntxiv ntawm cov xov xov hauv qhov chaw thaiv "Tus lej" nyem rau ntawm qhov icon Ntsig.
Koj tuaj yeem ua rau nws yooj yim dua me ntsis los ntawm kev ntaus ntawv ua ke nrog cov yuam sij kub Alt + F8.

Lub macro qhov rais pib. Hauv dab teb Macro Npe sau lub npe ntawm peb ntxiv-hauv "XlsToDBF" tsis muaj lus sib dhos. Kev tso npe tsis tseem ceeb. Tom ntej no nyem rau ntawm lub pob Khiav.

Lub macro hauv keeb kwm yav dhau los ua. Tom qab ntawd, hauv tib lub nplaub tshev uas cov ntaub ntawv Excel nyob qhov twg, ib qho khoom nrog DBF txuas ntxiv yuav tsim nrog lub npe uas tau teev nyob rau hauv lub cell A1.

Raws li koj tuaj yeem pom, hom txheej txheem no yuav muaj ntau cov nyom dua li qhov ua dhau los. Ntxiv rau, nws yog qhov tsawg heev hauv cov naj npawb ntawm cov teb siv thiab cov hom khoom tsim nrog DBF txuas ntxiv. Lwm qhov tsis txaus ntseeg yog tias lub dBase object creation directory yuav raug muab ua ntej txheej txheem hloov dua siab tshiab, los ntawm ncaj qha txav cov ntaub ntawv Excel cov ntaub ntawv mus rau cov chaw ceev ntaub ntawv. Ntawm qhov zoo ntawm cov qauv no, nws tuaj yeem sau tseg tias, tsis zoo li yav dhau los, nws yog dawb kiag li thiab yuav luag txhua tus siv tau ncaj qha los ntawm Excel interface.

Txoj Kev 3: Microsoft Nkag Mus

Txawm hais tias cov ntawv tshiab tshiab ntawm Excel tsis muaj txoj hauv kev los cawm cov ntaub ntawv hauv DBF hom, txawm li cas los xij, cov kev xaiv siv Microsoft Access daim ntawv thov tau ze tshaj plaws los hu nws tus qauv. Qhov tseeb yog tias cov program no yog tso los ntawm cov chaw tsim khoom zoo ib yam li Excel, thiab tseem muaj nyob hauv Microsoft Office suite. Tsis tas li ntawd, qhov no yog qhov kev xaiv nyab xeeb tshaj plaws, txij li koj yuav tsis tas ua qhov cuam tshuam nrog software thib peb. Microsoft Access yog tshwj xeeb tau tsim los rau kev ua haujlwm nrog cov ntaub ntawv.

Rub tawm Microsoft nkag

Tom qab tag nrho cov ntaub ntawv tsim nyog ntawm daim ntawv ua haujlwm hauv Excel tau nkag mus, txhawm rau hloov lawv mus rau DBF hom, koj yuav tsum xub khaws rau hauv ib qho ntawm Excel hom. Txhawm rau ua li no, nyem rau ntawm lub icon nyob rau hauv daim ntawv ntawm tsis xaiv neeg nyob rau sab saud sab sauv ntawm qhov kev pab cuam lub qhov rai.

Lub qhov rais qhib. Mus rau hauv phau ntawv teev npe uas peb xav kom muab cov ntaub ntawv khaws tseg. Nws yog los ntawm daim nplaub tshev uas koj yuav xav tau qhib nws tom qab hauv Microsoft Access. Cov qauv ntawm phau ntawv tuaj yeem sab laug los ntawm kab ntawv xlsx, lossis koj tuaj yeem hloov mus rau xls. Hauv qhov no, qhov no tsis yog qhov tseem ceeb, vim peb tseem khaws cov ntawv cia li hloov nws mus rau DBF. Tom qab txhua lub sijhawm tau ua tiav, nyem rau ntawm lub pob Txuag thiab kaw qhov rai Excel.

Peb tso qhov kev pab cuam Microsoft Access. Mus rau hauv lub tab Cov ntaub ntawvyog tias nws qhib rau lwm lub tab. Nyem rau ntawm daim ntawv qhia zaub mov "Qhib"nyob rau sab laug ntawm lub qhov rais.

Cov ntaub ntawv qhib qhov rai pib. Peb mus rau qhov chaw taw qhia qhov peb tau khaws cov ntawv hauv ib qho ntawm Excel daim ntawv. Yog li ntawd nws tshwm nyob rau hauv lub qhov rai, tig cov ntaub ntawv hom hloov mus rau "Excel phau ntawv ua haujlwm (* .xlsx)" lossis "Microsoft Excel (* .xls)", nyob ntawm qhov twg ntawm lawv phau ntawv tau txais kev cawmdim. Tom qab lub npe ntawm cov ntaub ntawv peb xav tau yog pom, xaiv nws thiab nyem rau ntawm lub pob "Qhib".

Qhov rai qhib Txuas rau Daim Ntawv TxuasCov. Nws tso cai rau koj kom hloov cov ntaub ntawv los ntawm cov ntaub ntawv Excel rau Microsoft Access. Peb yuav tsum xaiv daim ntawv Excel los ntawm qhov peb tab tom yuav import cov ntaub ntawv. Qhov tseeb yog tias txawm tias Excel ntawv muaj cov ntaub ntawv ntawm ob peb nplooj ntawv, koj tuaj yeem import nws nkag mus rau hauv Kev nkag mus nyias tsuas yog thiab, raws li, tom qab ntawd hloov nws mus rau hauv cov ntaub ntawv DBF cais.
Nws tseem tuaj yeem nqa cov ntaub ntawv ntawm ib tug twg ib ntu ntawm nplooj ntawv. Tab sis hauv peb qhov, qhov no tsis tsim nyog. Teeb tus tes hloov mus rau txoj haujlwm Cov ntawv txheeb, thiab tom qab ntawd xaiv daim ntawv los ntawm qhov chaw uas peb yuav mus coj cov ntaub ntawv.Qhov tseeb ntawm cov zaub ntawm cov ntaub ntawv tuaj yeem saib ntawm hauv qab ntawm lub qhov rais. Yog tias txhua yam txaus siab, nyem rau lub pob "Tom ntej".

Ntawm lub qhov rais tom ntej, yog tias koj lub rooj muaj cov ntawv sau, cim lub npov nyob ze "Kab thawj muaj cov kem npe"Cov. Nyem ntawd tag khawm "Tom ntej".

Hauv qhov rais tshiab rau kev txuas rau daim ntawv nthuav tawm, koj tuaj yeem xaiv hloov lub npe ntawm cov khoom txuas. Nyem ntawd tag khawm Ua li cas.

Tom qab ntawd, lub npov xov tooj qhib nyob rau hauv uas yuav muaj cov lus hais tias qhov kev sib txuas ntawm lub rooj nrog Excel cov ntawv tiav. Nyem rau feem khawm "OK".

Lub npe ntawm lub rooj uas peb muab rau nws nyob rau hauv lub qhov rais kawg yuav tshwm nyob rau sab laug ntawm sab xis ntawm cov program interface. Ob npaug nyem rau nws nrog tus laug nas khawm.

Tom qab ntawd, lub rooj yuav tshwm rau hauv lub qhov rai. Txav mus rau tab "Cov ntaub ntawv sab nraud".

Ntawm txoj hlua rau ntawm pob khawm "Export" nyem rau ntawm cov tsiaj ntawv "Tshaj"Cov. Hauv daim ntawv qhib uas, xaiv "Cov ntaub ntawv DBase".

Cov export rau DBF hom qhov rai qhib. Hauv dab teb "Cov ntaub ntawv npe" Koj tuaj yeem qhia lub chaw ntawm cov ntaub ntawv thiab nws lub npe, yog tias cov uas tau teev tseg los ntawm lub neej ntawd tsis haum koj vim qee yam.
Hauv dab teb "Cov hom ntaub ntawv" xaiv ib ntawm peb hom qauv DBF:
- dBASE III (los ntawm neej ntawd);
- dBASE IV;
- dBASE 5.
Nws yuav tsum raug sau tseg tias tam sim no ntau dua hom ntawv (qib siab ntau tus naj npawb), ntau txoj hauv kev muaj rau kev ua cov ntaub ntawv hauv nws. Ntawd yog, nws yog qhov ntau dua tias txhua cov ntaub ntawv hauv lub rooj tuaj yeem khaws cia hauv ib qho ntaub ntawv. Tab sis tib lub sijhawm, nws tsis tshua zoo tias qhov kev zov me nyuam koj xav tau yuav cov ntaub ntawv DBF yav tom ntej yuav tau tshaj hom hom no.
Tom qab kev teeb tsa txhua lub sijhawm, nyem rau lub pob "OK".

Yog tias tom qab ntawd cov lus yuam kev tshwm sim, tom qab ntawd sim xa cov ntaub ntawv siv ntau hom DBF hom. Yog tias txhua yam ua tiav zoo, lub qhov rai zoo li tau tshaj tawm tias cov export tau ua tiav. Nyem rau feem khawm Kaw.

Tus tsim cov ntaub ntawv dBase yuav nyob rau hauv cov npe teev hauv qhov rai export. Ntxiv nrog nws koj tuaj yeem ua txhua qhov kev ntxias, suav nrog kev coj mus rau lwm cov haujlwm.

Raws li koj tuaj yeem pom, txawm hais tias qhov tseeb tam sim no ntawm Excel tsis muaj lub peev xwm los khaws cov ntaub ntawv hauv DBF hom nrog cov cuab yeej muaj, txawm li cas los xij, tus txheej txheem no tuaj yeem nqa tawm siv lwm cov kev pabcuam thiab cov ntxiv. Nws yuav tsum raug sau tseg tias txoj kev ua haujlwm tshaj plaws ntawm kev hloov pauv yog siv WhiteTown Converters Pob hlauv taws xob. Tab sis, hmoov tsis, tus naj npawb ntawm kev hloov pauv dawb hauv nws tau txwv. Lub XlsToDBF add-on tso cai rau koj hloov dawb kiag li, tab sis cov txheej txheem muaj ntau nyuab dua. Ntxiv rau, cov haujlwm ntawm qhov kev xaiv no muaj qhov tsawg heev.

Lub Ntsiab Lus Golden yog ib txoj kev siv Siv Nkag. Zoo li Excel, qhov no yog kev loj hlob ntawm Microsoft, thiab yog li koj tuaj yeem tsis hu nws ua daim ntawv thov thib peb. Ntxiv rau, qhov kev xaiv no tso cai rau koj los hloov cov ntawv Excel ua ntau hom dBase hom. Txawm hais tias Kev Nkag mus tseem qis dua WhiteTown hauv qhov ntsuas no.

Send