Mohlala ona o tla u ruta mokhoa oa ho kenya data ho tsoa polokelong ea Microsoft Access u sebelisa Microsoft Query Wizard. U sebelisa Microsoft Query, u ka khetha litšiea tse lakatsehang ebe u li kenya ho Excel feela.
- Ho Advanced tab Lintlha (data) tobetsa Ho tsoa mehloling e meng (Ho tsoa mehloling e meng) ebe u khetha Ho tsoa ho Microsoft Query (Ho tsoa ho Microsoft Query). Ho tla hlaha lebokose la puisano Khetha Mohloli oa Boitsebiso (Khetha mohloli oa data).
- khetha MS Access Database* ebe u tšoaea lebokose le haufi le khetho Sebelisa Wizard ea Query ho theha/ho fetola lipotso (Sebelisa Wizate ea Potso).
- Press OK.
- Khetha database ebe o tobetsa OK.Database ena e na le litafole tse 'maloa. O ka khetha tafole le likholomo ho kenyelletsa potsong.
- Totobatsa tafole bareki ebe o tobetsa konopo e nang le letšoao ">".
- Press E 'ngoe (Ho feta).
- Ho kenya feela dataset e boletsoeng, e sefa. Ho etsa sena, khetha maikutlo a Lethathamong Kholomo ea ho sefa (Likholomo bakeng sa khetho). Ka ho le letona, lethathamong la pele la ho theoha, khetha ho lekana (e lekana), 'me ka lekhetlo la bobeli lebitso la motse - New York.
- Press E 'ngoe (Ho feta).
Database ena e na le litafole tse 'maloa. O ka khetha tafole le likholomo ho kenyelletsa potsong.
U ka hlophisa data haeba u batla, empa re hana.
- Press E 'ngoe (Ho feta).
- Press fihlela qetellong (E entsoe) ho romella data ho Microsoft Excel.
- Khetha mofuta oa tlhahisoleseling moo o batlang ho beha data teng ebe o tobetsa OK.
sephetho:
Hlokomela: Ha database ea Access e fetoha, o ka tobetsa khatholla. (Nchafatsa) ho khoasolla liphetoho ho Excel.