Ib Daim Ntawv Cuam Tshuam Siv Qhia Ncua Ncua Tebchaws 2003 Ntxig rau Excel

Ib kauj ruam ntawm kauj ruam mus rau Access 2003

Nws yog feem ntau yuav tsum tau hloov cov ntaub ntawv khaws tseg rau hauv ib qho Access 2003 database rau lwm daim ntawv, xws li ib phau ntawv Excel. Koj tuaj yeem xav tau coj kom zoo dua qee tus ntawm Exxees lub peev xwm los sis sib qhia cov ntaub ntawv nrog lwm tus neeg tsis paub nrog Kev Nkag Mus. Xijpeem vim li cas, kev hloov siab los ntseeg yog ncaj ncaj.

Nyeem kom Export Access 2003 Ntxig rau Excel

Cov ntawv nyeem no siv cov qauv Northwind , yog li koj yuav tsum paub tseeb tias nws tau nruab. Tom qab koj ntse nruab nws, ua raws li cov kaujruam no xa mus rau cov lus qhua tuaj rau lub Excel workbook .

1. Qhib cov Northwind database .
2. Thaum lub Northwind Switchboard tshwm, nias lub Dias Window lub khawm kom nkag mus rau hauv lub ntsiab database.
3. Yog tias koj tsis tau nyob hauv Table rooj, nias qhov Ntxhuav Xaiv hauv Cov Khoom Siv Cov Khoom Siv rau sab laug ntawm Database window.
4. Double-click Customers lub rooj nyob rau hauv Database qhov rais qhib lub rooj.
5. Los ntawm cov ntawv qhia zaub mov, xaiv qhov kev xaiv Export .
6. Koj yuav tsum tam sim no pom ib lub thawv uas muaj lub npe hu ua "Export Table 'Customers' To ..." Qhia cov hom xa tawm los xaiv Microsoft Excel 97-2002 los ntawm cov "Txuag li hom" cov ntawv qhia zaub mov.
   1. Thaum koj tuaj nqa cov ntawv qhia zaub mov no, nqa cov lus qhia txog "Save as type" zaub mov. Koj tuaj yeem siv tib txoj kev no los mus nthuav tawm cov rooj rau ntau yam ntaub ntawv, nrog rau lwm cov ntawv qhia xws li Paradox thiab dBASE. Kev nkag tau muab kev ywj pheej ntawm kev yooj yim los ntawm kev tso cai rau koj mus export cov ntaub ntawv rau cov ntaub ntawv ODBC-raws cov ntaub ntawv los yog cov ntaub ntawv dawb.
7. Qhia kom meej rau ib daim ntawv filename hauv "File name" textbox.
8. Nyem qhov Export All khawm kom tiav cov txheej txheem xa khoom.

Thaum koj ua tiav cov txheej txheem no, qhib Excel spreadsheet kom paub tseeb tias cov ntaub ntawv tau muab coj los ua tiav. Yog tag nrho nws muaj nws!

Lus cim : Cov lus qhia no siv tau rau Kev Nkag 2003 thiab ua ntej dhau los.