ACC2000: Error Message When You Export an Access 2000 Table That Has a Numeric Field to an Oracle Database (272346)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q272346
Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you use a DSN that you created with the Microsoft ODBC Driver for Oracle to export an Access 2000 table to an Oracle database, you receive the following error message:
Microsoft Access was unable to append all the data to the table.

The contents of fields in 1 record(s) were deleted, and 0 record(s) were lost due to key violations.

If data was deleted, the data you pasted or imported doesn't match the field data types or the FieldSize property in the destination table.

If records were lost, either the records you pasted contain primary key values that already exist in the destination table, or they violate referential integrity rules for a relationship defined between tables.
If you click Yes to this error message, the table structure is created in the Oracle database. However, no data is inserted into the table.

If you click No to this error message, neither the table structure nor the data are exported to the Oracle database.

RESOLUTION

Change the field size of the Number field to decimal, and then export the table to an Oracle database.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. On a computer that has the Oracle client utilities installed, create a DSN with the Microsoft ODBC Driver for Oracle.
  2. In a Microsoft Access 2000 database create a table that has the following structure:
       Table: Table1
   ------------------------
   Field Name: Field1
   Data Type: Number
   Field Size: Long Integer
  3. Open the new table in Datasheet view, and then type 154 as the first record.
  4. On the File menu, click Export.
  5. In the Files of type list, click ODBC Databases.
  6. In the Select Data Source dialog box, select the DSN that you created in Step 1, and then click OK.
  7. Click OK to accept the default name of the table to be created in the Oracle database.

    Note that you receive the error message that is mentioned in the "Symptoms" section. Click Yes to the error message.
  8. Using the Oracle client utilities, locate the database that the table was created in. Note that the table structure appears correctly, but that there is no data in the table.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbbug kberrmsg KB272346
©2004 Microsoft Corporation. All rights reserved.