;;Dear All , ; ;;Please help me for Update item Master alias tdls file . ;;Code Given below [Collection: ExceltemMasterAliasCollection] ODBC : "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=D:\Import Template\ST Alias.xlsx" SQL : "Select * from [Sheet1$]" [Function: STAliasImport] Variable : TotalEntries : String Variable : Count : Number 00 : Set : TotalEntries : $$NumItems:ExceltemMasterAliasCollection 10 : Start Progress: ##TotalEntries : "Update Stock Item Alias" : "Importing Stock Item Alias" : ##SVCurrentCompany 20 : Walk Collection : ExceltemMasterAliasCollection 30 : Alter Object : STOCKITEM 40 : Set Value : Name : $_1 50 : Save Target : .. 60 : Insert Collection Object: Name 70 : SET VALUE : Name : $_2 80 : SET VALUE : LANGUAGEID : "1033" 90 : Create Target : .. 330 : SAVE TARGET 340 : Show Progress : ##Count 350 : Increment : Count 360 : End Walk 370 : End Progress 380 : Msg Box : "Status" : "Item Master Alias Imported Successfully" [#Menu: Gateway of Tally] Add : Item : Before : @@locQuit : "Import Stock Item Alias" : Call : STAliasImport