update query that has a syntax error when run

[Guest]

Hello. I have been working with access 97 for awhile now. The database that
I am working with was created before I began working with the company I am at
now. The database is used to manipulate data that is in text format and will
be used to update a SQL server 7 database. In this case an update query is
run to retrieve the data from an imported table and then have the results of
the query loaded into a new table. During this process 2 of the 3100 or so
rows are not processed because these two unknown rows are not the correct
format (I am guessing text or alpha-numeric data) vs number only data. I am
not sure on the extact error, just that a text box pops up at the end of
running the update query stating that two rows were rejected because of a
syntax error.

My question is, is there a way to have the results of the update query sent
to a result table such as when you import data, an error table is created to
show what rows were not loaded or accepted if you will because of what ever
error.

If I could identify the fault rows, then I would know what values are not
correct and I could fix them or choose another column.

Edward Letendre.

 

[Allen Browne]

Depending on how you are performing the append, you may find that Access
creates a table containing the unprocessable rows. The table will be called
"Paste Errors" or "Import Errors" or something fairly obvious.

If there is no table, you could instruct Access to complete the append
withtout the 2 rows, and then use the Unmatched Query Wizard (first dialog
when you create a query) to find out which records are in the original table
but not in the new table.