Hi Trying to Import from Excel Sales Invoice. Get the following Error. PFA for Pic Attached Code in TDL is [Collection: Excel Sales] ODBC : "ODBC : "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=" + @@SyExcelFilePath SQL : "Select * from [Sheet1$]" ;SQL : "Select Distinct `Inv_No`,`Inv_Date`from [Sheet1$]" SQLObject : Sy Sales Object Client Only : Yes Format : $_1 Format : $_2 Format : $_18 Format : $_17 Using tally erp 9 4.92 32bit
ODBC : "ODBC : "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=" + @@SyExcelFilePath try this ODBC :"Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=" + @@SyExcelFilePath