Creating a " Archive table" for 30 days to contain all data imported from multiple text files

[Keevo]

Good Morning

i'm in the process of creating an Access database to import data in text files and then export the data as fixed width text files, this is now working fine

My next step is to be able to setup an "Archive" Table which will hold all the data i have imported across multiple import proceudres for the last 30 days, i then want to be able to "De-Dupe" any files i import against this to ensure i never load duplicate data.

Hope this makes sense and thanks for taking the time to look into my question.

regards

Craig

[ranman256]

If you have a field you can KEY , dump the data into a keyed table and there will be no duplicates.