Import Query

[Jamie Longmire]

Hi everyone,
I want to import some data from an external source into Table A but I want
the query to check Table B to see if the data has already been imported.
Can anyone advise how this can be done?

Regards,
Jamie

 

[Jeff Boyce]

Jamie

One approach would be to link to the external data, then write your query
between the external data and TableB to find the values NOT in TableB (the
query wizard has a Not-In query template).

I'm curious, though, why you would need values in both TableB and TableA?
It sounds like you are making sure that TableB doesn't already have the
values you are adding to TableA -- what are you actually storing in these?