O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

G.9. The ImportExportSpecification Object

Access 2007 introduces a new technique for creating and managing import and export specifications. If you worked with specifications in previous versions of Access, you'll be glad to know that you can create a specification for each of the supported file types for import and export! No longer are specifications limited to text files. With the addition of this new feature, Microsoft has added the ImportExportSpecification object and ImportExportSpecifications collection. Obviously, this collection contains ImportExportSpecification objects and consists of the standard collection members: Add, Item, Count.

G.9.1. ImportExportSpecification Object Properties

The following table describes the properties of the ImportExportSpecification object.

PropertyData TypeDescription
ApplicationApplication objectReturns the current Application object for the specification.
DescriptionStringSpecifies a friendly description for the specification.
NameStringSpecifies the name of the specification.
ParentObjectthe CurrentProject or CodeProject object for the specification.
XMLStringSpecifies the XML representation of the specification.

G.9.2. ImportExportSpecification Object Methods

The ImportExportSpecification object's methods are described here:

MethodArgumentsDescription
DeleteNoneDeletes the current specification.
ExecutePromptExecutes the import or export specification.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required