Help with SQL

[CDM]

I import an XLS spreadsheet into an Access table every morning. The new
table lists all of our customers with the date and amount of their last
payment. I've written a routine that adds new pmts for each customer to a
PmtHistory table using code that basically works like this:
For each row in tblXLS
Open a recordset in PmtHistory looking for tblXLS.Customer_Id and
tblXLS.PmtDate
If .eof then: Add a new record
Next

I'm wondering if there is an SQL statement that could do this faster?

 

[CDM]

Thanks for your help! I'll post back if I get into trouble.

 

[alan stivers]

katelynidstuf