Insert Data Table: The LEVEL clause includes a reserved word or argument that is misspelled

I’m using the Insert Data Table activity to insert into an Access database. The activity works multiple times throughout the workflow but on one instance I’m getting this error:

“Microsoft Access Database Engine - The LEVEL clause includes a reserved word or argument that is misspelled or missing, or the punctuation is incorrect.”

Any ideas?

Hi @bcarp

The error is related to the access database you are using… the word “LEVEL” is a keyword in access database :slight_smile:
so If you are to use keywords, you will need to wrap it with square brackets [LEVEL]

That will solve the issue

3 Likes

For everyone’s reference, here is a lit of reserved keywords in Access:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.