Prepared statement setting alternative solution?

I would probably try to do this as a loop with where as much of the query as possible is hardcoded (inserting one record at a time if needed)