MS Access 2007 Step By Step - Asim Abbasi
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Chapter 6: MS Access Data Import/Export Feature
Verify by Opening Exported File

Figure 6-6: MS Excel software with MS Access exported data.
________________________________________
Double click the exported MS Excel file. The exported data will get
opened into MS Excel environment provided you have MS Excel software
installed in your system.
In a real life, whenever we have to submit some information/report to
someone or to some department, we usually send it in MS Excel format.
There is no sense of sending someone MS Access database because not only
the file would be comparatively bigger but the complexity would be
another issue. MS Excel files are usually very light weight (small size)
and easy for end users to read and manipulate compared to MS Access.
Chapter 6: MS Access Data Import/Export Feature
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Share with others: