Data extraction in access

[charles1664]

Hi

I have a long list of trade numbers (10000) that maps to a large table of
data.

I do not want extract any data on these number. I want to exclude all data
relating to these trade numbers. When you link the data base is there a way
to say link these two tables and bring back everything else listed in the
data base

Is this possible?

thanks

 

[Arvin Meyer [MVP]]

Link to the external table. In a query add the linked table and the table
with the link numbers that you don't want. Change the Join properties by
clicking on the Join and choosing All the records from the import table.

Add the * From the import table, and the Trade Numbers Column a second time.
Use the following criteria:

Not In([ImportTableName].[Trade Numbers])

Check that the rows shown are the ones you want, and if so, change your
query to an append query to get the data you want.