I am using excel as database it contains 8 columnsI 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 actionbut it throwing error saying-There is syntactical error in sql statement -sql statement got timed out

Concat excel columns in SQL

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 tsheetname$$] set t8thcol] = concat(c1stCol],o2ndcol])” in insert/update /delete action

but it throwing error saying

-There is syntactical error in sql statement

-sql statement got timed out

Be the first to reply!