Hello, guys!
Here's the deal: I got an excel worksheet with informations about tickets of a system. I've already imported it to an Access table. Now I need to import periodically similar worksheets. I tried to do it by using the import wizard, as I did when I imported for the first time, but this new sheet contains some registries that are already in the table (with the same primary key) and need to be updated, so I got an error mesage saying that some registries were lost for key violations. That is, it does not get updated, it just ignores those registries. What's the best way to do it?
It follows an worksheet as example:
Exemplo Planilha.zip