Run Command Insert statement have syntax error

[nkdesai (nirmal.desai)]

Syntax error in
“INSERT INTO [Contract,Price Master$] (Log Date) VALUES ('”+Today.ToString(“dd-MM-yyyy”)+“')”

Can anyone please solved it?

Note: specially for excel

[Parvathy (PS Parvathy)]

Hi @nkdesai

Try this:

"INSERT INTO [Contract,Price Master$] ([Log Date]) VALUES ('" + Today.ToString("dd-MM-yyyy") + "')"

Hope it helps!!

[rlgandu (Rajyalakshmi Gandu)]

@nkdesai

"INSERT INTO [Contract,Price Master$] ([Log Date]) VALUES ('" & Date.Today.ToString("dd-MM-yyyy") & "')"

[nkdesai (nirmal.desai)]

Thank you @Parvathy for the solution

[nkdesai (nirmal.desai)]

Thank you @rlgandu for the solution

[Parvathy (PS Parvathy)]

You’re welcome @nkdesai

Happy Automation!!

[nkdesai (nirmal.desai)]

if Column name is like “Amendment / Revision #”, How we can define “#” in insert query ?

[Parvathy (PS Parvathy)]

Hi @nkdesai

Try this once:

"INSERT INTO [Contract,Price Master$] ([Log Date], [Amendment / Revision #]) VALUES ('" + Today.ToString("dd-MM-yyyy") + "', 'YourValueHere')"

Hope it helps!!