Microsoft Query Wizard mu Excel

Chitsanzochi chidzakuphunzitsani momwe mungatengere deta kuchokera ku Microsoft Access database pogwiritsa ntchito Microsoft Query Wizard. Pogwiritsa ntchito Microsoft Query, mutha kusankha mizati yomwe mukufuna ndikulowetsa mu Excel yokha.

1. Pa Advanced tabu Deta (data) dinani Kuchokera ku Zina Zina (Kuchokera kuzinthu zina) ndikusankha Kuchokera ku Microsoft Query (Kuchokera ku Microsoft Query). A dialog box adzaoneka Sankhani Gwero la Data (Sankhani gwero la data).
2. Sankhani MS Access Database* ndipo onani bokosi pafupi ndi njirayo Gwiritsani ntchito Query Wizard kupanga/kusintha mafunso (Gwiritsani ntchito Query Wizard).
3. Press OK.
4. Sankhani database ndikudina OK.Dongosololi lili ndi matebulo angapo. Mukhoza kusankha tebulo ndi mizati kuti muphatikizepo mu funso.
5. Onetsani tebulo makasitomala ndipo dinani batani lomwe lili ndi chizindikiro ">".
6. Press Ena (Zowonjezera).
7. Kuti mulowetse mndandanda wa data womwe watchulidwa, sefani. Kuti muchite izi, sankhani maganizo M'ndandanda Mzere woti usefe (Mizere yosankhidwa). Kumanja, m'ndandanda wotsitsa woyamba, sankhani zofanana (zofanana), ndipo pachiwiri dzina la mzinda - New York.
8. Press Ena (Zowonjezera).

Mutha kusanja deta ngati mukufuna, koma sititero.

9. Press Ena (Zowonjezera).
10. Press chitsiriziro (Zachitika) kutumiza deta ku Microsoft Excel.
11. Sankhani mtundu wa chidziwitso chomwe mukufuna kuyikapo deta ndikudina OK.

Zotsatira:

Zindikirani: Pamene Access database ikusintha, mukhoza kudina kulunzanitsa (Refresh) kuti mutsitse zosintha ku Excel.