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

Help Studio
, ,
1

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 !!

2

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') ;"

image
image796×318 16 KB

thanks
VP

3

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.

image
image944×45 2.71 KB

4

@mittal.abhishek066

Have u tried without punctuation and run the query

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

5

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

Regards

6

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

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

7

@LAKSHMI_NARAYANA_PEMMASAN - Same issue occuring after removing the quotes

8

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

try with square brackets for column name

Regards

9

@LAKSHMI_NARAYANA_PEMMASAN see below screenshot

image

10

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

https://www.youtube.com/playlist?list=PL41Y-9S9wmyLAVPs4oS8t0QlGAC8cIVXF

Regards

11

@mittal.abhishek066

Can U try this Expression with : Run query activity