I am writing some vba code in excel to insert/update rows in an access table. I've done queries into access through excel before, but can't for the life of me figure out the proper way to write this query.
I need to test if a productid exists in the table and if it does update the row with values, if it doesn't exist, then insert a new row with values.
I have SQL code from a vb.net program I wrote a while ago that does this, but of course access SQL is pretty picky. A query with an access udf won't work or I would have done that (since this is run from excel).