Inserting/Updating

[detlion1643]

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).

[MAF4Fam6]

I am clueless on how to write VBA in Excel.
However, if for some reason, you are unable to find a solution...I have written an extensive Tutorial in the Forums on how to accomplish this via a Macro (launched from a Command Button's OnClick Even on a Form).

To view the Tutorial, Click here.

-RC