Isikhokelo esiKhuselekileyo sokuPhumelela kokuFikelela kweeTables 2003 kwi-Excel

I-Step-by-Step-Step-Step-Tutorial for Access 2003

Kufuneka ukuba uguqule idatha egciniwe kwisiseko se-Access 2003 kwelinye ifomu, njengencwadi ye-Excel. Unokufuna ukuxhamla ezinye ze-Excel ezikhethileyo zokuhlalutya okanye ukwabelana ngolwazi nomntu ongaqhelekanga ngoFikelelo. Kungakhathaliseki isizathu, ukuguqulwa kwenkqubo kuchanekileyo.

I-Tutorial yoThengiselo lwe-Export Access 2003 kwi-Excel

Le tutorial isebenzisa isiseko sesampula yaseNorthwind , ngoko kuya kufuneka uqinisekise ukuba ifakwe. Emva kokuba uyifake ngempumelelo, landela le nyathelo ukuthumela iithebula zabaxhasi kwiincwadi ze-Excel .

1. Vula iNewwind database .
2. Xa i-Switchboard yaseNorthwind ibonakala, nqakraza ikhonkco lokubonisa idilesi yeWindows ukuze ufinyelele kwisikrini esisezantsi.
3. Ukuba awusekho kwiDibrari yokujonga, nqakraza iifayile ezikhethiweyo phantsi kweMenyu yezinto ezikhethiweyo kwicala lasekhohlo le window.
4. Nqakraza kabini iithenda zabaThengi kwiwindow yeDeskithophu ukuvula itafile.
5. Ukusuka kwimenyu yefayile , khetha ukhetho lokuthumela ngaphandle .
6. Ngoku kufuneka ubone ibhokisi yencoko ebizwa ngokuthi "Export Table" Abaxhasi 'Ukuze ... "Cacisa ifomathi yokuthumela ngaphandle ngokukhetha iMicrosoft Excel 97-2002 ukusuka kwimenyu ethi" Gcina njengoluhlobo ".
   1. Xa upheqa le menu, qaphela izinto ezahlukeneyo kwi "Imenyu yokugcina" njengemenyu. Ungasebenzisa le nkqubo efanayo ukuthumela amathebula okufikelela kwiifom ezahlukeneyo, kubandakanye nezinye iinkcukacha ezifana neParadox kunye neDBASE. Ufikelelo lubonelela ngokukhululeka ngokuvumela ukuba uthumele idatha kwiphina imithombo yedatha ehambelanayo ne-ODBC okanye ifayili yombhalo ocacileyo.
7. Cacisa igama lefayile elifanelekileyo kwi "Igama lefayile" ibhokisi leencwadi.
8. Cofa kwi- Export All iqhosha ukugqiba inkqubo yokuthumela.

Emva kokuba uzalise le nkqubo, vula i-spreadsheet ye-Excel ukuqinisekisa ukuba idatha ihanjiswe ngempumelelo. Kukho konke okukho kuyo!

Qaphela : Le miyalelo isebenza kwi-Access 2003 kunye neenguqulelo zangaphambili.