Hello,
Thank you for posting in Q&A forum.
This erroring Microsoft Visual Basic (VBA) generally indicates a mismatch between the number of parameters in your SQL query and the number of parameters you're providing in your VBA code.
Please kindly check:
- If you provide the right placeholders for parameters.
- If parameter names used can be found in VBA code.
Hope this answer can help you well.