Part III: More-Advanced Access Techniques
634
l (^) On the basis of the first row’s contents, Access automatically chose the incorrect
data type for a field. The first row is correct, but the remaining rows are blank.
l (^) The date order may be incorrect. The dates are in YMD order, but the specification calls
for MDY order. When Access tries to import 991201 (YYMMDD), it will report an error
because it should be in the format of 120199 (MMDDYY).
Import errors for existing tables
Access might not be able to append records into an existing table for the following reasons:
l (^) The data is not consistent between the file being imported and the existing Access table.
l Numeric data being entered is too large for the field size of the Access table.
l (^) A row in a text file or spreadsheet may contain more fields than the Access table.
l The records being imported have primary-key values that duplicate existing primary keys
in the destination table.
Exporting to External Formats
An export copies data from an Access table to some other application or data source, such as an
XML document. The exported result uses the format of the destination data source and not the for-
mat of an Access database. You can copy data from an Access table or query into a new external
file. You can export tables to several different sources.
Note
In general, anything imported can also be exported, unless otherwise stated in this chapter.
Exporting objects to other Access databases
When the destination of an export process is an Access database, you can export every type of
Access object (tables, queries, forms, reports, and so on). To export an object to another Access
database, follow these generic steps:
- Open the source database and select an object to export.
- Click the More button under the Export section of the External Data tab, and select
Access Database as the export destination.
The Export–Access Database dialog box appears.
- Use the Browse button to locate the destination Access database.
Note
The target database can’t be open, or else a locking conflict occurs.
- Clicks OK, and the export process proceeds.