How to export data from Access :
- Open the object that contains the data you want to export.
- On the External Data tab, in the Export group, click the format or program you want to export to.
- 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.
- 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.
- In the Export dialog box, select Save export steps.
- Enter a name for the export steps (or accept the default name) and enter a description.
- If you want to, select the option Create Outlook Task.
- Click Save Export.
How to run a saved export :
- On the External Data tab, in the Export group, click Saved Exports.
- In the Manage Data Tasks dialog box, select the export operation you want to run, and then click Run
No comments:
Post a Comment