Append Query

  • Thread starter Thread starter Edgar
  • Start date Start date
E

Edgar

Hi

I am new to access so this may be easy but I cant figure
out how to do it.

I import data into my db from excel daily. This goes into
a tempory table called tblimport.

The imported data can sometimes contain duplicates and
also some of the fields may not be entered. What I want to
do is to append this data to my main table (tblprices)
excluding all duplicates and for fields with no data in
them to be copied to another table for me to review later
(tblerrors)

Can anyone give me any pointer into how this should be
done?

TIA
 
The imported data can sometimes contain duplicates and
also some of the fields may not be entered. What I want to
do is to append this data to my main table (tblprices)
excluding all duplicates and for fields with no data in
them to be copied to another table for me to review later
(tblerrors)
Click to expand...

You'll need a couple of Append queries. First create one with a
criterion of

IS NOT NULL

on the fields that you want to enforce as non-blank; set this query's
UNIQUE VALUES property to True to remove duplicates, and append it to
tblPrices.

Then do the reciprocal query using a criterion of IS NULL to append to
tblErrors.
 
Back
Top