When you run an import wizard or export wizard in Microsoft Office Access 2007, you can save the settings you used as a specification so that you can repeat the operation at any time. A specification contains all the information Access needs to repeat the operation without your having to provide any input.
For example, a specification that imports data from a Microsoft Office Excel 2007 workbook stores the name of the source Excel file, the name of the destination database, and other details, such as whether you appended the data to an existing table or imported the data into a new table, primary key information,and field names.
You can save an import or export operation involving any of the file formats supported in Access. You cannot save the details of a linking operation or an operation where you export only a portion of a datasheet.
Although the main objective of a specification is to save all the major details so that you can repeat the import or export without user input, a specification is still very flexible. For example, you can change the name of the source file or the destination file before you run the specification again. This way, you can use a single specification with several different source or destination files.
A specification that exports formatted data to Excel or Microsoft Office Word 2007 will respect the current filter and column settings of the source object in Access. If the source object (table, query, form, or report) is open when you run the specification, Access exports only the data that is currently displayed in the view. If the source object is not open, the settings that were most recently saved with that object will determine what data is exported.
Create an import or export specification
- Start the import or export operation from Access.
The import and export wizards are available on the External Data tab. The import wizards are in the Import group, and the export wizards are in the Export group.
Available wizards for importing data to or exporting data from common file formats
The following articles describe each of the import and export wizards available in Access:
- Follow the instructions in the wizard. After you click Finish, and if Access successfully completes the operation, the Save Import Steps or Save Export Steps page appears in the wizard.
- On the wizard page, click Save import steps or Save export steps to save the details of the operation as a specification.
Access displays an additional set of controls. This figure shows the dialog box with those controls available.
- In the Save as box, type a name for the specification.
- In the Description box, type a description to help you or other users identify the operation at a later time.
- To create an Outlook task that reminds you when it is time to repeat this operation, click Create Outlook Task.
- Click Save Import or Save Export to save the specification.
Access creates and stores the specification in the current database.
- If you clicked Create Outlook Task on either the Save Import Steps or Save Export Steps page of the wizard, an Outlook Task window appears. Fill in the details of the task and then click Save & Close.
Note that you cannot copy or move the specification to another database, but you can do the following:
- Perform an operation by using a specification.
For more information, see the article Run a saved import or export operation.
- Schedule automatic execution of a specification at regular intervals.
For more information, see the article Schedule an import or export operation.
- Change the name or the description of the specification, or delete the specification from the database. You can also update the name of the destination file in an import specification or the source file in an export specification.
For more information, see the article Manage Data Tasks.
Top of Page