automated importing (csv file)

[Tanya Addison]

I have successfully created code to import a csv file into access on a four weekly bases. The code then append the import into a larger table and creates a couple of additional columns. This main table is linked to a Parent table with a primary key and I have created Ref. Integ to prevent any records being imported that do not have a known code. I now need to know how I trap the records that do not make it into the main table into a seperate table of their own. can anyone help?

 

[bat17]

You could import the data to a new table and run an umatched query between the master table and your imported data.

HTH

Peter

 

[Tanya Addison]

I am importing two files every four weeks which append to a main table. Whilst appending they calculate new fields so that I can run a match and create ref int. What happens to all the records that do make ref int? I just want to catch them in a make table.

thanks

 

[bat17]

I dont think that anything happens to them, they are just filtered out. Presumably though you could match your imported table against your main data to see which records are in the import but not in the main table.

Peter