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

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

 

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

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

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: