Question

Concat excel columns in SQL

  • 26 April 2023
  • 0 replies
  • 48 views

Badge

I am using excel as database it contains 8 columns

I need to update the 8 th column with concate of first 2 columns 

i used “update [sheetname$$] set  [8thcol] = concat([1stCol],[2ndcol])” in insert/update /delete action

but it throwing error saying

-There is syntactical error in sql statement 

-sql statement got timed out

 


0 replies

Be the first to reply!

Reply