banner banner Skip to main content

Tally ODBC Driver Issue


Based on the Operating System bit (32/64) Tally has given the Exe. However the Micro Soft Excel application should be compatible to O/S and Tally.ERP9.

Please note, On 64 Bit OS and 64Bit Tally.ERP9, a 32 Bit Excel application can act as a server with following steps.

Please download from the Portal- ‘Microsoft Access Database Engine 2010 Redistributable’. 

1. Install AccessDatabaseEngine_x64.exe Installed (steps given below separately.)

2. Excel 32 Bit (Excel 2003) Installed – and acting as server

3. Tally 64 Bit As Client – 
                    with ODBC Driver [ODBC: "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=C:Tally.ERP 9 4.5 Build 7Sample Data.xls;"]
and 
Tally 32 Bit as Client – with ODBC Driver [ODBC : "Driver={Microsoft Excel Driver *.xls)};DBQ=Sample Data.xls"]

This will resolve the problem by NOT upgrading MS Office to 64 bit. you can continue using 32 bit application of Excel.
Labels:

Comments

  1. NITU17 August 2018 at 05:56

    Thanks for such good information.
    There are many way to import vouchers from Excel to Tally. You can create XML file can import it in Tally under import of data option. But for that you have to know knowledge of Tally XML tag. Also some online tool is available which it auto create XML from Excel data and directly import it in Tally.
    Download template at - http://www.xltally.in

    ReplyDelete
  2. TIPA11 September 2018 at 04:36

    I just would like to give you a big thumbs up for the great information you share on this post.

    Tally course in delhi

    ReplyDelete
  3. Unknown1 November 2019 at 00:43

    Thanks for sharing this articles.Amazing tips given by you
    tally training institute in delhi
    tally training institute in gurgaon
    tally training institute in noida

    ReplyDelete
  4. high technologies solutions14 November 2019 at 02:46

    Thanks for Sharing the Post.
    tally training center in delhi
    tally training center in delhi

    ReplyDelete
  5. high technologies solutions27 November 2019 at 21:53

    Nice post,thanks for posting
    tally training institute in delhi
    tally training institute in Noida

    ReplyDelete
  6. high technologies solutions1 December 2019 at 22:29

    such an interesting post shared by you
    tally training institute in Noida
    tally training institute in delhi

    ReplyDelete
  7. High Technologies Solutions8 February 2020 at 03:28

    Thanks for Sharing a very Nice Information & It’s really helpful for us.

    Tally Training Institute in Delhi
    Tally Training Institute in Noida

    ReplyDelete
  8. high technologies solutions5 March 2020 at 02:41


    Join the best and leading tally training institute in Delhi and Noida. High Technologies Solutions believes in quality training and provide innovative friendly environment.We also provide live projects, Assignments, free demo class and placement assistance. Call at 9311002620.
    Tally training institute delhi
    Tally training institute in Noida

    ReplyDelete
  9. High Technologies Solutions17 January 2021 at 01:03

    Tally training is best job oriented training for commerce as well as non-commerce/arts students, those who are seeking immediate employment can join this course

    Tally Training Institute in Delhi

    ReplyDelete
  10. PRADEEP RAY27 April 2021 at 12:08

    Thanks Sir

    ReplyDelete
  11. PRADEEP RAY27 April 2021 at 12:10

    for any kind of tally customization you can connect with Us.

    https://pradeepray.com/contact/

    https://pradeepray.com/2021/04/27/tally-unlimited-level-of-voucher-approval/

    https://pradeepray.com/

    ReplyDelete
  12. high technologies solutions1 May 2021 at 23:14

    Thank you for sharing this content its the same i looking for again a big thank you for sharing this post by the way If anyone look for Ms Office training institute in Delhi Contact Here-+91-9311002620 Or Visit our website https://www.htsindia.com/Courses/microsoft-courses/ms-office-course

    ReplyDelete
  13. high technologies solutions5 May 2021 at 21:54

    Thank you for sharing this type of content in your post. Your content is really good, by the way. If anyone looking forbest Sas training institute in Delhi Contact Here-+91-9311002620 Or Visit our website https://www.htsindia.com/Courses/business-analytics/sas-training-institute-in-delhi

    ReplyDelete
  14. jackr7610 May 2021 at 04:09

    Glad to check this blog because it’s a nice and informative blog.
    Tally Course in Chennai
    CCNA Course in Chennai
    SEO Training in Chennai
    Hadoop Training in Chennai
    Cloud Computing Training in Chennai
    Blue Prism Training in Chennai

    ReplyDelete
  15. high technologies solutions19 May 2021 at 00:56

    Thanks for sharing this amazing post this is the content i really looking for, it's very helpful i hope you will continue your blogging anyway if anyone looking for ms office training institute in delhi contact us +91-9311002620 visit-https://www.htsindia.com/Courses/microsoft-courses/ms-office-course

    ReplyDelete
  16. Dreamsoft Consultants4 June 2021 at 03:50

    Thank you for sharing this great post its very helpful but if anyone looking for Experience Certificate Providers in Delhi, India with Complete Documents So Dreamsoft Consultancy is the Best Place.Further Details Here- 9599119376 or Visit Website- https://experiencecertificates.com/experience-certificate-provider-in-delhi.html

    ReplyDelete

Post a Comment

Popular posts from this blog

LOG In function

During expression evaluation, intermediated values of the expression can be passed to calculator window and a log file ‘tdlfunc.log’ inside the application directory. This is very much helpful for debugging the expression. By default, logging is enabled inside the function. Syntax LOG : < Expression> Where, is the expression whose value needs to be passed to the calculator window. [Function : GetCurrentUserApprovelAmt] Parameter : PsvCurrentUser : String Variable : ApprovelAMT : Amount Return : Amount  10 : Walk Collection : ApprovelRequredColl  11 : If : $CustVAUser =  ##PsvCurrentUser  12 : Set : ApprovelAMT : $ApprovelAmount  12A : Log : ##ApprovelAMT  13 : End If  14 : End Walk  15 : Return : ##ApprovelAMT
Post a Comment
Read more

Differences between Applications and DLLs

Differences between Applications and DLLs Even though DLLs and applications are both executable program modules, they differ in several ways. To the end user, the most obvious difference is that DLLs are not programs that can be directly executed. From the system's point of view, there are two fundamental differences between applications and DLLs: An application can have multiple instances of itself running in the system simultaneously, whereas a DLL can have only one instance. An application can own things such as a Stack, Global memory, File handles, and a message queue, but a DLL cannot.
Read more