Results 1 to 2 of 2
May 26, 2005, 04:43 #1
selecting values which do not match
hi there i need to display results that do not match those in the database. I have an excel file and i upload it, inserting the records in a temp table. Than i compare the values in the original table and the temp table. All i want is the values that do not match..
i did this:
sql = "SELECT TempSerial.SerialNo "&_ "FROM TempSerial, Serial WHERE TempSerial.SerialNo <> Serial.SerialNo "&_ "OrderBY TempSerial.SerialNo;" Set RS = objConn.Execute(sql)
May 26, 2005, 22:14 #2
haha solved it already