Working on MS access Database where need to insert value in one column

I am running simple insert query and getting syntax error:

"Insert into [dbo_check_outstanding][(PS CASE)] values (“123456”) ; "

Error getting:

Insert: Syntax error (missing operator) in query expression ‘PS CASE’.

Can anyone pls suggest what i am doing incorrectly .

Thanks in Advance !!

Hi @mittal.abhishek066
No need to mention this Square braket .
Just write the Expression like this inside the quotes.

"Insert into dbo_check_outstanding (PS CASE) VALUES ('123456') ;"


Thanks for sharing solution but getting error:

Insert: The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.


Have u tried without punctuation and run the query

"INSERT INTO dbo_check_outstanding (PS CASE) VALUES ('123456') "

if the column is of type number then try without quotes for value


No , i have tried in a same way as u given to me.

“Insert into dbo_check_outstanding (PS CASE) VALUES (‘123456’) ;”

@LAKSHMI_NARAYANA_PEMMASAN - Same issue occuring after removing the quotes

can you show what activity you are using and how you have give the query

try with square brackets for column name


@LAKSHMI_NARAYANA_PEMMASAN see below screenshot


i guess there are some clarifications needed

As per your initially you are just insert a record but using insert activity which is for datatable insert

is you table has only one column ? if not then you have to pass blank values for the rest

Can you please go through the below tutorial , you get an idea



Can U try this Expression with : Run query activity