Microsoft KB Archive/272346

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

Article ID: 272346

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



Steps to Reproduce the Behavior
 On a computer that has the Oracle client utilities installed, create a DSN with the Microsoft ODBC Driver for Oracle.  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  Open the new table in Datasheet view, and then type 154 as the first record. On the File menu, click Export. In the Files of type list, click ODBC Databases.</li> In the Select Data Source dialog box, select the DSN that you created in Step 1, and then click OK.</li> 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 &quot;Symptoms&quot; section. Click Yes to the error message.</li> 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.</li></ol>

Additional query words: pra missing not there nothing valus

Keywords: kberrmsg kbbug KB272346

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.