Wannan misalin zai koya muku yadda ake shigo da bayanai daga rumbun adana bayanai na Microsoft Access ta amfani da Wizard Query Microsoft. Amfani da Microsoft Query, zaku iya zaɓar ginshiƙan da ake so kuma ku shigo da su kawai cikin Excel.
- A kan Babba shafin data (data) danna Daga Sauran Sources (Daga wasu kafofin) kuma zaɓi Daga Microsoft Query (Daga Microsoft Query). Akwatin maganganu zai bayyana Zaɓi Tushen Bayanai (Zaɓi tushen bayanai).
- zabi Database Access Database* kuma duba akwatin kusa da zabin Yi amfani da Mayen Tambaya don ƙirƙira/gyara tambayoyin (Yi amfani da Mayen Tambaya).
- latsa OK.
- Zaɓi bayanan bayanai kuma danna OK.Wannan bayanan bayanan ya ƙunshi teburi da yawa. Kuna iya zaɓar tebur da ginshiƙai don haɗawa cikin tambayar.
- Hana tebur Customers sannan danna maballin tare da alamar">".
- latsa Next (Ƙari).
- Don shigo da ƙayyadadden saitin bayanai kawai, tace shi. Don yin wannan, zaɓi City A cikin jerin Rukunin don tacewa (Shafukan don zaɓi). A hannun dama, a cikin jerin zaɓuka na farko, zaɓi daidai (daidai), kuma a cikin na biyu sunan birni - New York.
- latsa Next (Ƙari).
Wannan bayanan bayanan ya ƙunshi teburi da yawa. Kuna iya zaɓar tebur da ginshiƙai don haɗawa cikin tambayar.
Kuna iya tsara bayanan idan kuna so, amma ba za mu iya ba.
- latsa Next (Ƙari).
- latsa Gama (An yi) don aika bayanan zuwa Microsoft Excel.
- Zaɓi nau'in nunin bayanin inda kake son sanya bayanan kuma danna OK.
Sakamako:
lura: Lokacin da Access database ya canza, za ka iya danna kore gajiya (Sake sabuntawa) don zazzage canje-canje zuwa Excel.