Tuesday, September 22, 2015

Materi Microsoft Access : Export, saved and run data from Access

How to export data from Access :
  1. Open the object that contains the data you want to export.
  2. On the External Data tab, in the Export group, click the format or program you  want to export to.
  3. In the Export dialog box, specify the file name and location, and select the export options you want to use: to include formatting and layout, to view the exported file, and to export only selected records.
  4. Depending on the export option you select in step 2, use the dialog boxes and wizards Access provides to specify file format and related export options.
 How to save export steps :
  1. In the Export dialog box, select Save export steps.
  2. Enter a name for the export steps (or accept the default name) and enter a description.
  3. If you want to, select the option Create  Outlook Task.
  4. Click Save Export.

How to run a saved export :
  1. On the External Data tab, in the Export group, click Saved Exports.
  2. In the Manage Data Tasks dialog box, select the export operation you want to run, and then click Run

No comments:

Post a Comment