Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Concatenation in SQL Query to Excel

I often use SQL Query to get data from Excel. 

Last time I needed to read one column and add some prefix to each value.

'SQL Query' action uses 'MS Access' SQL notation for Excel, so I tried the following syntax options:

  • &
  • concat
  • concatenate
  • +
No luck, each time I get 'Syntax error: missing operator'

Does anyone know how to use concatenation in SQL Query to Excel?

Login or Signup to post a comment