This content has been marked as final. Show 4 replies
You could import to a temporary table, then do a SELECT DISTINCT on the fields that you are checking for dups before doing your insert.
That's what I do, anyway.
I forgot to mention - don't forget that impacts the rights they need in the datasource definition!
use this type of insert query
insert into mytable
select distinct values
where somefield = somevalue) = 0
Thank you guys. This works great!