Vba code delete duplicated records

[kanelones]

Hi!

Can you help me to avoid duplicated records on importation from excel to acces?

Need to add a VBA code line in order to do so..

Thanks a lot for you invaluable help.!

Regards

 

[Joe4]

If you set the Primary Key fields on your table, it will not allow duplicate records to be imported, and automatically block them from being imported without any need for any special code.

Alternatively, if the records are Excel are truly duplicates (where every field is the same), it would be even easier to use Excel's built-in "Remove Duplicates" functionality before importing.

 

[kanelones]

Thanks! I'm new with Acces.
Can you please explain it to me,? where do i find this "Primary Key Fields"?

 

[kanelones]

Already saw that, Thanks a lot!

 

[Joe4]

Thanks! I'm new with Acces.
Can you please explain it to me,? where do i find this "Primary Key Fields"?

Already saw that, Thanks a lot!

So, are you saying that you are all set, or are you still in need of something?

 

[kanelones]

Its fine, got what i wanted, Thanks!