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
Step 2: Select File Location, Format & Name
Figure 6-4: Export to MS Excel format.
________________________________________
1. Export Table window will pop up after the completion of step 1.
Select the location/folder as well as name where you would like to save
your data file as shown in Figure 6-4 with label 1 by clicking the
<Browse..> Button.
2. As depicted with label 2 (see the zoomed version Figure 6-5), this
drop down combo box contains all the different data formats available to
you for export operation. In the example, we are exporting the data into
MS Excel format.
3. Give the file a name. This will be the file containing the exported
data.
4. As shown in Figure 6-5, click the <Export data with formatting and
layout> check box.
5. Finally click the <OK> button.
After this you will see your computer doing something for a while and
finally a message window will pop up informing you that the data has
been exported successfully. Depending on the quantity of data that you
are exporting out of MS Access, you may have to wait a while. But in our
case it’s not going to be that much as the table we are exporting is
really small.
Once you have the data exported into MS Excel format, you can easily
view it in MS Excel application.
Figure 6-5: Zoomed version of Figure 6-4
________________________________________
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: