Nzira yekuenzanisa sei mafaira maviri e CSV ane MS Access

Zvinogona kuitika kuguma nematafura maviri akasiyana, mauri kuda kungoziva kuti chii chaicho chakasiyana, kunyanya apo iwe unotarisira zvakawanda zve data.


Enzanisa maviri maSVV mafaira ekusiyana mune Access

Zvinogona kuitika kuguma nematafura maviri akasiyana, mauri kuda kungoziva kuti chii chaicho chakasiyana, kunyanya apo iwe unotarisira zvakawanda zve data.

Ndinokurudzira iwe nzira iri nyore yekukurumidza kusiyanisa pakati pematafura maviri - chikamu chakaoma chete ndechokuti uwane maitiro akanaka!

Danho rekutanga nderokuwana mabhuku maviri eExpcel, somuenzaniso wekare (mufananidzo 1) uye itsva (mufananidzo 2).

Tarisa kuti mabwendefa maviri aya ane emiromo yakafanana muchirongwa chakafanana nemazita akasiyana, uye kuti yekutanga ine chinyararire chinozivikanwa - zvinoreva kuti hapana kamwe kaviri kukosha kwakafanana mumutsara uyu mukati mefaira rimwe chete, uye iyo mitsetse iyo yose mafaira ane uwandu hwakafanana mune iyi column.

Uyewo, unogona kuda kuronga matafura ako, sezvo purogiramu isingaiti - unogona kushandisa standard Excel oda basa kuti uite saizvozvo.

Zvino, iwe unofanirwa kushandura yako Excel matafura mu CSV. Vhura ipapo, uye sarudza Faira => Chengetai ... => CSV (Comma delimited) (*. CSV), nokuda kwefaira rekutanga (Figu 3), uye zvakare zvakare yefaira repiri (mufananidzo 4) .

Iwe zvino unogona kutora database yeku Access ini ndinokupa iwe [1] uye urichengetedze mune imwe faira seyese yako maF CSV.

Vhura iyo uye sarudza mutauro wako mumenyu yeMacrosi (Fig 5), uye purogiramu ichakukumbira kuti upe zita rekutanga faira (mufananidzo 6) kuenzanisa nechechipiri (mufananidzo 7).

Ngwarira kupa zita rakazara re csv faira, uye kuti ive yavo iri mune imwe faira, kana kuti iwe uchawana kukanganisa (mufananidzo 11).

Kuenzanisa mafayela maviri eSVV

Iva excel Pro: Joinha kosi yedu!

Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.

Nyoresa pano

Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.

Somugumisiro, iwe uchakwira kusvika kumafaira 3, zvichienderana nemhando yezvikanganiso zvakawanikwa:

- faira yekutanga ine mitsetse mitsva (Fig 8) inowanikwa mumutsara wechipiri asi kwete mufaira yekutanga, uye yakawanda yemitsetse mitsva muzita refaira,

- faira yechipiri nemitsetse yakadzingwa (Fig 9) isina kuwanikwa mumutambo wechipiri asi yakawanikwa mufaira yekutanga, nehuwandu hwemitsetse yakabviswa muzita refaira,

- firiji yechitatu ine sero inoshanduka (mufananidzo 10) kubva kune imwe yekare kusvika kune imwe nhanho, pamwe nekuwanda kwekushandurwa muzita refaira.

Muenzaniso mafaira akavakwa achishandisa Random Word Generator (Kuwedzera) [2].

Nzira yekuenzanisa matafura maviri muMSAccess

Kuenzanisa matafura maviri muMSAccess uye ona kusiyana kwechitanda nesero, kutengesa iwo seSVV mafaira, uye kushandisa shanduro yedu kuenzanisa tafura dze CSV muMSAccess.

Chigumisiro chichava kuenzanisa kwemafura maviri muAIDS ACCESS. Mutsara nemutsetse, chinyorwa nehomwe, uye sero nechitsauko kusiyana kweiviri ACCESS matafura kucharatidzwa mufaira rekupedzisira.

Kuenzanisa Dhiyabhorosi Dhiyabhorosi Pakati Pechipiri Inowanikwa MaTables Tables

Mibvunzo Inowanzo Bvunzwa

Maitiro ekufananidza mafaera maviri eCSV muExcel?
Kuenzanisa mafaera maviri eCSV muExcel, iwe unofanirwa kushandura matafura ako ezvekuita muCSV uye shandisa chishandiso kuenzanisa matafura eCSV. Chishandiso chinosimbisa mutsauko pakati pematafura maviri, kusanganisira mitsara mitsva, mitsara yakadzimwa, uye masero shanduko.
Ndeipi nzira inoshanda yekuenzanisa mafaera maviri eCSV uchishandisa Microsoft Access?
Ngenisa zvese zveCSV mafaera muzvikamu zvakaparadzana muMS kuwana, wobva washandisa mubvunzo kuti ubatane nematafura pane imwechete munda uye sarudza minda yekuenzanisa. Mhinduro dzekuwana dzinogona kuratidza zvinobudirira macheke, misiyano, uye discpancy pakati pematunhu maviri.

Zadzisa 2019 Excel yeVatanga mune vhidhiyo


Yoann Bierling
Nezvemunyori - Yoann Bierling
Yoann Bierling ibhusaiti yekushambadzira & Dhijitari Kukurukurirana Professional, kugadzira kukanganisa kwepasi rose kuburikidza nehunyanzvi uye hunyanzvi mune tekinoroji. Passionate nezve kupa simba vanhu uye masangano kuti akubudirire muzera redhijitari, anofambiswa kununura mhedzisiro yakasarudzika uye yekufambisa ichipfuura kuburikidza nedzidziso yezvinyorwa zvemukati.

Iva excel Pro: Joinha kosi yedu!

Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.

Nyoresa pano

Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.




Comments (17)

 2018-08-19 -  Sherry Moody
Gracias, muy informativo
 2018-08-19 -  Caleb Evans
Me encanta leer tu contenido, sigue publicando
 2018-08-19 -  Brandon Watts
Grazie, molto istruttivo
 2018-08-19 -  Roderick Franklin
Eu não sabia sobre esses detalhes, por favor, faça mais
 2018-08-19 -  Bobbie Estrada
Obrigado que foi útil
 2018-08-19 -  Randy Russell
Yani böyle yapıyoruz, bilmek güzel
 2018-08-19 -  Rufus Anderson
เรื่องดีขอขอบคุณสำหรับการแบ่งปัน
 2018-08-19 -  Edgar Brown
Nu știam despre aceste detalii, vă rog să faceți mai mult
 2018-08-19 -  Irene Moore
I’ll try it right now, thanks for sharing
 2018-08-19 -  Jane Cooper
Uau, é realmente assim tão simples, vai tentar agora
 2018-08-19 -  Phillip Sanchez
Eu vou tentar agora, obrigado por compartilhar
 2018-08-19 -  Goosearma
素晴らしいサイトです
 2018-08-19 -  FighterGrand
वास्तव में जो मैं खोज रहा था, बिल्कुल सही
 2018-08-19 -  xangarandaina6
정확히 내가 뭘 찾고 있었는지, 완벽 했어.
 2018-08-19 -  ynternaat0
Hallo, ik zag je artikel en het hielp me om mijn probleem op te lossen, heel erg bedankt
 2018-08-19 -  modderl
素晴らしい情報、共有のおかげで
 2018-08-19 -  abastanzaP
וואו, זה באמת כל כך פשוט, ינסו את זה עכשיו

Siya mhinduro