OpenRecordset with AddNew and Update would work.

Unless you need to loop to assign some values, it might be easier to just
build the Append query statement as a string (concatening values into it),
and Execute. Here's an example showing how to build and execute such a
string:
   http://allenbrowne.com/ser-60.html

If the string is long/complex, you can mock one up in the query window, and
copy'n'paste into your VBA code. This might help:
   Copy SQL statement from query to VBA
at:
   http://allenbrowne.com/ser-71.html

I understand that your original question no longer stands, but in general, a
parameter needs the same data type as the field it will be applied against.
And if you do use a Text parameter, and the parameter refers to a text box
on a form, JET won't handle it correctly when the text box is null:
   Parameter of type Text is evaluated wrongly
at:
   http://allenbrowne.com/bug-13.html