Hi,

I have been trying to update the chem_lookup (using acess database) however everytime I import the file, some anlytes get stuck with error messages.

When I import using the 'add new and update exisiting' I get a comment saying, "code already exists"

That's odd to begin with, but when I try to 'overwrite existing' (using both the selected line only and by attempting to overwrite the whole sheet) the same analytes are not imported with the comment, ' code does not exist'.

So when I try again, this time using the 'add new' import function I get the error message again, "code already exists".

This loop keeps happening, and I'm not sure what errors to check for in my populated template that might be causing this.

 Thanks.