Appending to Microsoft Access file in cloud storage error

Question

Whenever I try to append to an existing Microsoft Access file (accdb), I get the error: Error opening query: Microsoft Access Database Engine: No value given for one or more required parameters.

Does anyone have any idea on what might have caused this?

jonwyp · Answer

There is a possibility that one of the names of your columns from alteryx output is not matching with the name on the Access file. Are you able to double check the names of your columns on Access? Believe that the column you are trying to append can't be found and Access is treating it as a parameter.