Unable to Append All the Data to the Table

[Stewart Berman]

I have just started getting serious with Access 2007. I tried to import data from a text file and
append it to a table and got an error dialog box:
Microsoft Office Access was unable to append all of the data to the table.
The contents of fields in 0 records(s) were deleted, and 0 record(s) were lost due to key
violations.
< snip >
Do you want to proceed anyway.

I clicked on Yes and the append completed. All of the records and fields were appended.

I was doing the import manually and did not use any specifications.

Is this a know bug?

 

[Charles Wang [MSFT]]

Dear Stewart,
Welcome to Microsoft MSDN Managed Newsgroup.

Regarding this issue, based on my research, two main reasons for the
occurrence of the above error message are discussed below:
1. Appending of the records that were the primary key values
2. Violating referential integrity rules for a relationship defined between
tables

I recommend that you first try using an built-in repair utility ("Compact
and Repair") provided in MS Office. To use the utility, you will need to
follow these steps:
1. Go to the Tools menu, select Database Utilities and then click Compact
and Repair Database.
2. Locate and then click the database in the "Database to Compact From"
dialog box, and then click Compact.
3. Select an appropriate folder location for the new file in the "Compact
Database Into" dialog box, type a unique name for the file and then click
on Save.
In most cases, the inbuilt utility resolves your problem. However, if the
built-in utility is unable to resolve the issue, then you will need to opt
for powerful Access Repair utility. These Access Database Repair
applications employ effective scanning methods to completely scan and
repair the corrupted database. These applications can recover and restore
inaccessible Access databases (.mdb and .accdb).

Before you take the above action, please first save a copy of your access
database. In case it does not help, I recommend that you send me
(changliw_at_microsoft_dot_com) a copy of your Access database and the text
file to me so that I can quickly reproduce your issue and perform effective
research on it.

Thank you!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

 

[Stewart Berman]

1. Appending of the records that were the primary key values

2. Violating referential integrity rules for a relationship defined between
tables

Either of these would have resulted in records not getting appended. The error message said 0
fields were set to null and 0 records were not appended. All of the data was appended to the table.
It was the error message that was in error.

The incorrect error message was probably due to using Access 2207 on a database that is usually
processed with Access 2000. (I have 2000, 2002, 2003 and 2007 on this machine.)

If it happens again with 2000 I will try your suggestions.

 

[Charles Wang [MSFT]]

No problem, Steward. I look forward to you next response.

Thank you!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================