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

[bcarp (Bryan Carpenter)]

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?

[Lahiru.Fernando]

Hi @bcarp

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

That will solve the issue

[bcarp (Bryan Carpenter)]

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

https://support.office.com/en-us/article/learn-about-access-reserved-words-and-symbols-ae9d9ada-3255-4b12-91a9-f855bdd9c5a2