>>You didn't provide enough information about relationship between curLoaded and curImported to answer your question. My guess is that there're multiple records in curLoaded with the same cClient_Account_Number and they match some reoord(s) with the same cClient_Account_Number in curImported. IOW, I suspect that more than one field is involved in relationship between curLoaded and curImported.
>
>There are multiple records with the same cClient_Account_Number in both files, but this field is the best link we can have between these two files.
>
>Is there a way to get all records from curLoaded that were not imported?
You have to define what 'not imported' means in terms of tables fields.
--sb--