I am getting an error read on the second line - anyone know why? tnx k
CREATECURSOR email (email C(40))
INSERTINTO Email (Email) &&& syntax errorselect email from myDbf1 ;
UNION ;
SELECT email from myDBF2;
UNION ;
SELECT email from myDBF3;
UNION ;
SELECT email from myDBF4
> >UNION eliminates duplicates so the resulting cursor will have all unique emails from your 4 DBFs.