Beginning Access™ 2007 VBA

7.2. Access and Other Databases

You can use the TransferDatabase method of the DoCmd object to import from, link to, and export data to Access and several other databases, including SQL Server and Oracle. The basic syntax of the TransferDatabase method is shown in the following code:

DoCmd.TransferDatabase TransferType, DatabaseType, DatabaseName, ObjectType, Source, Destination, StructureOnly, StoreLogin

Various parameters are used to specify how the method should execute. The following table explains the use of each parameter.

Parameter	Description
TransferType	Type of transfer to be performed. Valid choices are acImport (default), acLink, and acExport.
DatabaseType	Type of database being used. Access is the default. See the help documentation for a complete list and for the exact syntax for a particular database.
DatabaseName	The full name, including the path, of the database being used.
ObjectType	The type of object that has data you want to work with. The default is acTable.
Source	Name of the object whose data you want to work with.
Destination	Name of the object in the destination database.
StructureOnly	Use True to work with the structure only and False to work with the structure and data. False is the default.
StoreLogin	Whether to store the login and password. False is the default.

Let's look at an example. Suppose that you want to import data from an Access database called SampleDb. The data you want to import is in a table called Sales, and you want it to be imported to your current ...