C
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?
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?