Chapter 17: Importing and Exporting Data
635
Note
Tables can be exported as data only or data and metadata.
- If an object already exists in the target database, you’ll be prompted whether you want to
replace the object in the target database. If you don’t, you can create a new object in the
target database. - The last step of the wizard enables you to save the export configuration for future use.
This option can be quite handy if you’ll be frequently performing the same export
process.
Note
If you try to export an object to another Access database that has an object of the same type and name, Access
warns you before copying. You then have the option to cancel or overwrite.
Exporting through ODBC drivers
Exporting using an ODBC driver connection to another relational database is a simple process. You
connect to the external database (in our case, an Oracle database). You then select a table to export
as shown in Figure 17.27.FIGURE 17.27Exporting Access tables to an ODBC destination