Hi All,
When I am trying to export a particular query to an Excel spreadsheet
( the .xlsx type) in get the error message "Microsoft Office Access
was unable to append all the data to the table. The contents of
fields in 7 record(s) were deleted, and 0 record(s) were lost due to
key violations. If data ... . "

I'm using Access 2007.

It only happens when exporting this particular query, all other
queries are fine. The query selects only from real tables, no
subqueries. All the tables have a primary key. I do not get the
error when I run the query, only when I try to export the query. It
occurs if I run a stored export or run one by right clicking on the
query. The export seems to work: all the data I expected to get is
being written to the target excel sheet.

I've only ever seen the error before when trying to insert or append
data that had a key violation.

Should I be worried about the database being corrupt? I've seen no
other weird behavior.

I made small changes to the query, saved the query then closed the
database, then opened the database, changed the query back, saved it
again, closed the db, then opened it again, to cause Access to re-
write the query, but the error persists.

Michael

Hmmm. Nobody replied to my question below. Maybe it's a really
stupid question, but even if that's so, I'd like someone to tell me
why it's stupid.
I just do not understand why I get an Append error when what I'm doing
is Selecting, and why I only get the error when Access is exporting
the results of the select and not when I just run the query from the
menu. What I'm really worried about is that something is very broken
in the database and that it might suddenly become corrupted and
unusable.
If someone has any insight into this issue, I'd be grateful.
Thanks,
Mike


On Mar 3, 10:50*am, Gilgamesh <michaelsfl... (AT) gmail (DOT) com> wrote:

Gilgamesh wrote:

aren't getting responses. It sounds more like an Append or Update query
you are attempting to export.

Is your mdb corrupted. Unlikely. But the error is not typical so
perhaps it is.

I might have a query like
Select CustID, CustName, CustCity From Customers

Then I attemp to export it to Excel. If it errors I would then delete a
column at a time and run the export process. It should error on one of
the columns. That'd help you debug the error I would think.

What version of Access are you using? Is the query a Select or is it an
Update?

Select a table and see if it exports correctly.