MS Access 2003 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 | 10 | 11 | 12 | 13 | 14 | 15
Step 3: Select File Location, Format & Name
1. Export Table window will pop up. Select the
location/folder where you would like to save your data file as shown in
the screenshot above. It’s a drop down combo box contains folders
information in your computer.
2. As depicted in the screenshot, 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. Finally click the <Export All> 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 of the quantity of data that you
are exporting out of MS Access, you may have to wait a while. But in our
case its 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.
Chapter 6: MS Access Data Import/Export Feature
Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
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: