ImportExportSpecification object (Access)

Represents a saved import or export operation.

Remarks

An ImportExportSpecification object contains all the information that Microsoft Access needs to repeat an import or export operation without your having to provide any input.

For example, an import 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 to or created a new table, primary key information, field names, and so on.

Use the Add method of the ImportExportSpecifications collection to create a new ImportExportSpecification object.

Use the Execute method to run a saved import or export operation.

Methods

Properties

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.