Access Data Repeats

[coreytba3]

In my database I transfer data via a .txt (text) file. Recently I have been observing repeats in my data. I input 40 different line items of text and it appears the repeats happen randomly. Also, if there are 6 line items that repeat, the last line item data repeats upwards. So the last line item repeats upwards. Also, the first column (sample ID) never repeats, only the data associated with that the last line item. Thanks!!

[rpeare]

In your processing is the incoming text file just new data (data you don't have) or is it a conglomeration of data? If it's a conglomeration and you're just appending records you are likely to see repeated data over time (I don't know what your dataset is so it's hard to say for sure). If there is even the smallest chance of data being repeated on your incoming text files you have to account for that on your import process (set up key fields that can't be duplicated in your access table)