Re: Help with SQL

katelynidstuf
"CDM" <CDM@[EMAIL PROTECTED]
> wrote in message 
news:C576FC7A-588D-430A-9522-79E967576CDD@[EMAIL PROTECTED]
> I im****t 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?
>