Skip to main content
Question

Excel as database

  • March 25, 2022
  • 1 reply
  • 40 views
M

Hi ,

​

I have an excel file with 2 sheets

Sheet1 -- column names(Id,name)​

Sheet2-column name(id,name)

​

I am using excel as db

​

I need to update ​sheet2 name column where sheet2(Id) is matched with sheet1 (Id)

​

Could you please send me uodate query

​

Thanks

Mahesh​

    1 reply

    A
    Automation Anywhere Team
    Forum|alt.badge.img+11

    Hello Mahesh,

     

    If you are using msssql, you can use the below query for the same:-

     

    update [SHEET2] set [name]='VALUE' where [id] = (select [id] from [SHEET1])

    Please try this query and let m know if any questions.

     

    Thank you,

    Prabhakar Jha

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings