Query Excel to Tally import TDL code is not working in Tally64 bit exe.32 bit Excel installed in my System. Solution Ensure that both Tally and MS Office are of same bit ness. i.e. if both applications are of 32 bit or 64 bit then both can communicate without any problem. If Tally application is 64 bit and acting as client and MS office (i.e Excel is 32 bit acting as Server) then ideally they cannot communicate with each other. However you can follow below steps to make both applications communicate with each other by using ODBC interface Install AccessDatabaseEngine_x64.exe by following the below steps:- a) Download the file - AccessDatabaseEngine_x64 to local system b) Open Command prompt with administrative rights c) Change Directory to exact file location. (Where the file AccessDatabaseEngine_x64 is located) d) Type this command and Enter -> AccessDatabaseEngine_x64/passive e) Once the Exe is installed. Re-start the Tally and proceed with the Import. Further, to read an Excel File irrespective of the formats, one can use the following connection string: "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=<Complete Path with File Name>;"
hi [#Collection: Active Batches VchExtract],here i have to fetch a rate field, but it's won't take a value.... any body can explain me or give a code
kindly follow the steps to make both xl and tally bitness same close tally and xl open CMD command in Administrator Mode go to your tally installation folder type setup.exe /bitness:32 ( if ur xl is 32 bit and tally 64 bit) or setup.exe /bitness:64 ( if ur xl is 64bit and tally 32 bit) it works for me
There is no TDL in this THREAD. This thread is about workability of 32 bit and 64bit. There are many others Excel to Tally Import TDLs in other threads. You can search for the same as per your requirements.
Install Tally 32 bit on your system there are one command in CMD setup /bitmess:32 something like that search in google for right command