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
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
Hi @nkdesai
Try this:
"INSERT INTO [Contract,Price Master$] ([Log Date]) VALUES ('" + Today.ToString("dd-MM-yyyy") + "')"
Hope it helps!!
"INSERT INTO [Contract,Price Master$] ([Log Date]) VALUES ('" & Date.Today.ToString("dd-MM-yyyy") & "')"
Thank you @rlgandu for the solution
You’re welcome @nkdesai
Happy Automation!!
if Column name is like “Amendment / Revision #”, How we can define “#” in insert query ?
Hi @nkdesai
Try this once:
"INSERT INTO [Contract,Price Master$] ([Log Date], [Amendment / Revision #]) VALUES ('" + Today.ToString("dd-MM-yyyy") + "', 'YourValueHere')"
Hope it helps!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.