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


 

MS Access has the ability not only to Export data out from its environment to any of the famous data formats but can also bring the outside data into its environment. In this section of the chapter we will be looking deep into the Export functionality of MS Access.

We will be looking into all those formats that MS Access can handle as far as Export and Import is concern in the next article.

 

Export Feature Overview

You can easily export data from MS Access environment into MS Excel, HTML etc. and all other formats mentioned in the slide below.

It doesn’t really matter whether the data reside in the MS Access Local Tables or Linked Tables or even comes as the output of a MS Access query, you can export it out from the MS Access environment.

Next we look into what are the steps to export the data out from MS Access and once you know how to export to any one of the formats, it applies to all other data export formats. The only thing that differs is merely the selection of that particular format from the drop down list.

 

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: