Hi Community,
I have the following queries about "Execute SQL"
1.- What syntax should I use to change the name of a column?
2.- What syntax should I use to delete rows?
1.- What syntax should I use to change the name of a column?
--> Are you using excel as database, change the Header(HDR) to YES in connection string. If first row has header then it will show in QueryResult.
2.- What syntax should I use to delete rows?
-->not sure but delete is not supporting. Use excel actions to format data.
Regards
Kaif