Question: I have a saved Excel Import in an Access Database that appends 'Payment data' each month to the 'Payments' table.

If someone were to run the import twice by mistake I noticed that Access simply appends the data twice to the table, thereby creating duplicate entries. 

How can I prevent the Import from importing entries that already exist in the Table?

**Fields in the Table include:**

* Invoice Number
* Payment Date
* Payment Amount
* Customer ID
* Customer Name
* Payment Type

Thanks

Answer: 
change
======

```
if symbolList(int(individualPassCounter)) == "A":

```

to
==

```
if symbolList[int(individualPassCounter)] == "A":

```

list objects are accessed with square brackets, not with parentheses. 
You also need to handle IndexError exceptions
Parens are used for calling functions. Square brackets are used for accessing sequences and mappings.

```
somelist[...]

```