Insert activity problem

[m.soto (M Salazar)]

Hello,

I am trying to insert a data table retrieved from excel sheet onto Access DB but I am getting the following error:

“Insert: Syntax error (missing operator) in query expression ‘Service ID’.”

I have a multiple fields and one is called ‘Service Account’. I want to use the “Insert” activity but cannot make it run successfully.
I tried to run a query in order to insert a value onto the faulty field and I was able to insert that value using the following query:
“INSERT INTO [passwordexpDB] ([Service Account]) values(‘ABC.mx’);”

Can you please help me to fix my ‘‘Insert’’ activity?

[AJ_Ask]

Can you share your Excel sheet. Will be easy to make query.

[m.soto (M Salazar)]

Log_11.07.2023 10.43.14.xlsx (9.6 KB)

Sure, thank you

[AJ_Ask]

Hi @m.soto

You can use the following query, Replace the table name with Output_Log also i have assign the the value of service_Account to a variable

“INSERT INTO Output_Log ([Service Account]) VALUES ('” + Service_Account + “')”

You can use something like this to assign value to variable

Hope This Helps

[m.soto (M Salazar)]

@AJ_Ask

'” +

Thank you, got my issue resolved.