Umhlahlandlela Osheshayo Wokuthumela Ezokungenisa Ezithempelini 2003 ku-Excel

Isifundo sezinyathelo ngezinyathelo zokufinyelela ku-2003

Kuvame ukudingeka ukuguqula idatha egcinwe kwisitatimende sokufinyelela ku-2003 kwenye ifomu, njengencwadi ye-Excel. Ungase ufune ukusebenzisa ngokunenzuzo ezinye ze-Excel ezikwazi ukuhlaziya okuhlukile noma ukwabelana nedatha nomuntu ongajwayelekile nge-Access. Kungakhathaliseki ukuthi yisiphi isizathu, inqubo yokuguqulwa iqondana kahle.

I-Tutorial Yokuthumela I-Export Access 2003 kumathebula ku-Excel

Le tutorial isebenzisa isampula ye - Northwind yesampula , ngakho kuzodingeka uqinisekise ukuthi ifakiwe. Emva kokufaka ngempumelelo, landela lezi zinyathelo ukuthekelisa ithebula lamakhasimende kubhuku le- Excel .

1. Vula i-database ye-Northwind .
2. Uma i-Switchboard yeNorthwind ibonakala, chofoza inkinobho yokubonisa i-Database Window ukuze ufinyelele kusikrini esikhulu semininingwane.
3. Uma ungasekho kakade ekuboneni kweThebula, chofoza inketho yeTables ngaphansi kwemenyu yezinhloso ngakwesokunxele kwewindi le-Database.
4. Chofoza kabili ithebula Labathengi kwiwindi YeDeskithophu ukuvula ithebula.
5. Kusukela kwimenyu yefayela , khetha inketho yokuthumela ngaphandle .
6. Manje kufanele ubone ibhokisi lengxoxo elibizwa nge- "Export Table" Abathengi 'Ku ... "Cacisa ifomethi yokuthumela ngaphandle ngokukhetha i- Microsoft Excel 97-2002 kusuka kwimenyu ethi" Gcina njengohlobo ".
   1. Uma upheqa le menyu, qaphela izinketho ezihlukahlukene kwimenyu "Gcina njengohlobo". Ungasebenzisa le nqubo efanayo ukuthekelisa amathebula okufinyelela kumafomu ahlukahlukene, kufaka phakathi ezinye zolwazi ezifana ne-Paradox nedBASE. Ukufinyelela kuhlinzeke ngokuguquguquka okukhulu ngokukuvumela ukuthekelisa idatha kunoma iyiphi imithombo yedatha ehambisana ne-ODBC noma ifayela le-text plain.
7. Cacisa igama lefayela elifanele ku "Igama lefayela" ibhokisi lokubhala.
8. Chofoza inkinobho yokuthumela konke ukuqedela inqubo yokuthekelisa.

Uma usuqedile le nqubo, vula ispredishithi se-Excel ukuqinisekisa ukuthi idatha ithunyelwe ngempumelelo. Yilokho okukhona kulokho!

Qaphela : Lezi ziqondiso zisebenza ku-Ukufinyelela 2003 nezinguqulo zangaphambili.