Dear Experts, I have written a code regarding Excel Import from Tally. Machine Specifications: 1. windows x64 bit machine 2.Tally ERP 9 6.5.1 x32 bit 3.Microsoft Excel 2007 x32bit I am trying import data from Excel but nothing is happening, what is error that making hindrance for the import. Here is code snippet and Excel sheet attached below: [Menu:Excel Import] Item : Import : Call : Mul Item Import Tool [Collection: Excel Contents] ODBC: "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=C:\Users\user\Desktop\Excel to Tally Import\Excel to Tally Import\Import.xlsx;";D:\Excel Import\Formate for tally.xlsx;" ;" SQLObject:ObjectSrc SQL : Select * from [Sheet1$] [Object:ObjectSrc] Ref:$_1 [Collection:FinalExcelColl] Source Collection : ExcelContents Fetch : *.*,* Fetch : Ref Compute : NewRef:$Ref [Function: Mul Item Import Tool] Variable : NewVchRef : String 001:Walk Collection:FinalExcelColl 002:Set:NewVchRef:$NewRef 003: Log:##NewVchRef 004:End Walk 005:Log:"Walked"
