Ngenisa data kubva Kupinda kuenda kuExcel

Uyu muenzaniso uchakudzidzisa nzira yekupinza ruzivo kubva kuMicrosoft Access database. Nekupinza data muExcel, iwe unogadzira chinongedzo chechigarire chinogona kuvandudzwa.

  1. Pa Advanced tabo Data (Data) muchikamu Wana External Data (Tora data rekunze) tinya bhatani Kubva Access (Kubva Access).
  2. Sarudza iyo Access file.Ngenisa data kubva Kupinda kuenda kuExcel
  3. Click Open (Vhura).
  4. Sarudza tafura wobva wadzvanya OK.Ngenisa data kubva Kupinda kuenda kuExcel
  5. Sarudza nzira yaunoda kuratidza iyo data mubhuku, kwaunoda kuisa uye tinya OK.Ngenisa data kubva Kupinda kuenda kuExcel

Mhedzisiro: Zvinyorwa kubva kuDatabhesi reKuwana zvakaonekwa muExcel.

Ngenisa data kubva Kupinda kuenda kuExcel

Cherechedza: Kana iyo Access data yachinja, unongoda kudzvanya dzozorodza (Refresh) kurodha shanduko kuExcel.

Leave a Reply