Dear Admin & All Experts, i am use the following code for import master from excel to Tally. When i use this code in Windows XP Machine with 32 Bit & MS Office is 2003 then code is working fine in Latest Tally Version 4.93. Problem is that Whin i change the Machine & use Windows 7 Or Above version with 32Bit , MS Office version 2007 or above it gives me an Errer. I Think here is a problem but i am not able to resolve it. PLS HELP [Collection : NS LedgermasterColl] ODBC : "Driver={Microsoft Excel Driver (*.xls)};DBQ=" + @@NSExcelFilePath SQL : "Select * from [Sheet1$]" SQLObject : NS Ledgermaster Object Client Only : Yes i have att. file here pls Help me. Awaiting for your replay's Manish
Dear ALL, Finaly i have Solved the Issue... This file is support both XLS & XLSX Files in 32 Bit or 64 Bit. File is Att. .... ENJOY !! MANISH
It is fine for if you need one by one record but what about to import all the records in that excel file? please suggest on modified code.