You copy your code, click the # on post toolbar, cursor will be within 2 code tags, you paste (ctrl+v) - and done.
Maybe to add a bit to the last post, modify your append query to restrict appends to where price field Is Not Null? You can test an action query by switching from SQL view to datasheet view. Sometimes that can be confusing though as what you'll see is what is going to be affected, not necessarily how it will be affected. At least it should show 1 of 3 things: it errors, it does nothing, it does something. If it errs, it usually returns to sql view and highlights the offending part but not always.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.