A Jagora Mai Saukin Kai don Aikawa Access 2003 Tables zuwa Excel

Ɗabiyayyen matakai don samun damar 2003

Ya zama wajibi ne don sauya bayanan da aka adana a cikin database na Access 2003 zuwa wani nau'i, kamar littafi na Excel. Ƙila ka so ka yi amfani da wasu fasaha na musamman na Excel ko don raba bayanai tare da wanda ba'a sani ba tare da Access. Duk dalilin da ya sa, tsari mai juyo yana da sauƙi.

Koyarwa zuwa Siyarwa Taimakawa 2003 Tafiyar zuwa Excel

Wannan koyaswar tana amfani da database na Arewawind , saboda haka kuna bukatar tabbatar da an shigar da shi. Bayan ka samu nasarar shigar da shi, bi wadannan matakai don fitarwa da tallace-tallace masu ciniki zuwa littafin littafin Excel .

1. Bude tushen Arewa .
2. Lokacin da Arewacin Switchboard ya bayyana, danna maɓallin Window na Nuni don samun dama ga allon dandalin bayanai.
3. Idan ba a riga ka gani a cikin Table ba, danna Zaɓin Zaɓin ƙarƙashin Objects menu a gefen hagu na Database window.
4. Danna sau biyu a cikin ɗakunan Kasuwanci a Database don bude teburin.
5. Daga Fayil din menu, zaɓi Zaɓin Fitarwa .
6. Ya kamata a yanzu duba akwatin maganganun da ake kira "Fitarwa Tebur" Abokan ciniki 'Don ...' Saka tsarin fitarwa ta zaɓar Microsoft Excel 97-2002 daga menu na "Ajiye kamar yadda".
   1. Lokacin da kake lilo wannan menu, lura da zaɓuka daban-daban a menu na "Ajiye azaman". Zaka iya amfani da wannan tsari don fitar da Tables na Access zuwa nau'o'i daban-daban, ciki har da wasu bayanai kamar Paradox da dBASE. Samun dama yana samar da matsala mai yawa ta hanyar kyale ka ka fitar da bayanai ga duk wani mahimmin bayanai na ODBC ko fayilolin rubutu.
7. Saka bayanai mai dacewa a cikin sunan "File name".
8. Danna maɓallin Export Duk don kammala tsarin fitarwa.

Da zarar ka kammala wannan tsari, bude maƙunsar Bayani na Excel don tabbatar da cewa an fitar da bayanan. Wannan duka shi ne!

Lura : Waɗannan umarnin suna amfani da Access 2003 da kuma juyi na baya.