General discussion

Locked

ODBC Connectivity of Tally 7.2 and Excel

By raonline2 ·
Dear Sir,

One of Our Client is using Tally 7.2. the problem is we are facing problem in accessing the tables thro ODBC Connectivity. Its not listing all the tables

Can you suggest me in doing that

Thanks and Regards
A.Rajesh

This conversation is currently closed to new comments.

10 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by wellmax1.maxwell In reply to ODBC Connectivity of Tall ...

you have set up SQL CONNECTION.
PROGRAMS,PERVASIVE,PERVASIVESQLV8,UTILITIES,ODBC ADMINISTRATOR.

Collapse -

ODBC Tally7.2

by rajkumar.phand In reply to

I am using ODBC to import data from Tally7.2 to Excel. In Excel I am not getting all information which available in tally. Wellmax can you explain what is
"you have set up SQL CONNECTION.
PROGRAMS,PERVASIVE,PERVASIVESQLV8,UTILITIES,ODBC ADMINISTRATOR" ???
From above statement I am unable to understand what to do exactly.

Collapse -

ODBC Tally7.2

by rajkumar.phand In reply to

I am using ODBC to import data from Tally7.2 to Excel. In Excel I am not getting all information which available in tally. Wellmax can you explain what is
"you have set up SQL CONNECTION.
PROGRAMS,PERVASIVE,PERVASIVESQLV8,UTILITIES,ODBC ADMINISTRATOR" ???
From above statement I am unable to understand what to do exactly.

Collapse -

ODBC Tally7.2

by rajkumar.phand In reply to

Wellmax can you explain what is
"you have set up SQL CONNECTION.
PROGRAMS,PERVASIVE,PERVASIVESQLV8,UTILITIES,ODBC ADMINISTRATOR" ???
From above statement I am unable to understand what to do exactly.

Collapse -

how to do vb and tally database connectivity?

by priyanka_kakad2000 In reply to ODBC Connectivity of Tall ...

i want my vb database(msaccess) into tally...so that i can save my time to reenter the database again into tally...pls reply me fast...

Collapse -

VB to Tally, VB.NET to Tally

by shwetarajkot In reply to how to do vb and tally da ...

You can use RTSlink DLL to integrate VB Applications with Tally, VB.NET to Tally. Visit www.rtslink.com and www.rtslink.blogspot.com

Collapse -

tally xml link

by srikrishnathanthri In reply to VB to Tally, VB.NET to Ta ...

See this code
reference MS xml 3.0
Private Sub Command1_Click()
Dim strRequestXML '? store request XML

''strRequestXML = _
''"<ENVELOPE>" & _
''" <HEADER>" & _
''" <TALLYREQUEST>Export Data</TALLYREQUEST>" & _
''" </HEADER>" & _
''" <BODY>" & _
''" <EXPORTDATA>" & _
''" <REQUESTDESC>" & _
''" <REPORTNAME>List of Companies</REPORTNAME>" & _
''" <STATICVARIABLES>" & _
''" <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>" & _
''" </STATICVARIABLES>" & _
''" </REQUESTDESC>" & _
''" </EXPORTDATA>" & _
''" </BODY>" & _
''"</ENVELOPE>"

''strRequestXML = _
''"<ENVELOPE>" & _
''" <HEADER>" & _
''" <TALLYREQUEST>Export Data</TALLYREQUEST>" & _
''" </HEADER>" & _
''" <BODY>" & _
''" <EXPORTDATA>" & _
''" <REQUESTDESC>" & _
''" <REPORTNAME>trial balance</REPORTNAME>" & _
''" <STATICVARIABLES>" & _
''" <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>" & _
''" </STATICVARIABLES>" & _
''" </REQUESTDESC>" & _
''" </EXPORTDATA>" & _
''" </BODY>" & _
''"</ENVELOPE>"


''strRequestXML = _
''"<ENVELOPE>" & _
''" <HEADER>" & _
''" <TALLYREQUEST>Export Data</TALLYREQUEST>" & _
''" </HEADER>" & _
''" <BODY>" & _
''" <EXPORTDATA>" & _
''" <REQUESTDESC>" & _
''" <REPORTNAME>list of accounts</REPORTNAME>" & _
''" <STATICVARIABLES>" & _
''" <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>" & _
''" </STATICVARIABLES>" & _
''" </REQUESTDESC>" & _
''" </EXPORTDATA>" & _
''" </BODY>" & _
''"</ENVELOPE>"


''strRequestXML = _
''"<ENVELOPE>" & _
''" <HEADER>" & _
''" <TALLYREQUEST>Export Data</TALLYREQUEST>" & _
''" </HEADER>" & _
''" <BODY>" & _
''" <EXPORTDATA>" & _
''" <REQUESTDESC>" & _
''" <REPORTNAME>Voucher register</REPORTNAME>" & _
''" <STATICVARIABLES>" & _
''" <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>" & _
''" </STATICVARIABLES>" & _
''" </REQUESTDESC>" & _
''" </EXPORTDATA>" & _
''" </BODY>" & _
''"</ENVELOPE>"


''strRequestXML = "<ENVELOPE><HEADER><TALLYREQUEST>Export Data</TALLYREQUEST></HEADER><BODY><EXPORTDATA><REQUESTDESC><REPORTNAME>List of Accounts</REPORTNAME><STATICVARIABLES><SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT><ACCOUNTTYPE>Ledgers</ACCOUNTTYPE></STATICVARIABLES></REQUESTDESC></EXPORTDATA></BODY></ENVELOPE>"


strRequestXML = "<ENVELOPE><HEADER><TALLYREQUEST>Export Data</TALLYREQUEST></HEADER><BODY><EXPORTDATA><REQUESTDESC><REPORTNAME>Trial balance</REPORTNAME><STATICVARIABLES><SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT><LEDGERTYPE>Ledgers</LEDGERTYPE></STATICVARIABLES></REQUESTDESC></EXPORTDATA></BODY></ENVELOPE>"


'Use the version dependent PROGID of the ServerXMLHttp 'object if referencing MSXML 4.0.
'( MSXML2.ServerXMLHTTP40 )
Dim obj As MSXML2.ServerXMLHTTP
Set obj = New MSXML2.ServerXMLHTTP
'obj.open "GET", "http://winmansoftware.com/index.htm"
'obj.send


'obj.open "POST", "http://192.168.1.62:9000" 'obj.open "POST", "http://192.168.1.62:9000?, FALSE"
obj.open "POST", "http://pc62:9000"

obj.send strRequestXML

If obj.Status >= 400 And obj.Status <= 599 Then
MsgBox "Error Occurred : " & obj.Status & " - " & obj.statusText
Else
Text1.Text = obj.responseText
End If

End Sub

Code currently requests Trial balance. But Trial balance returned is group wise. We want it in Ledger wise format. Therefore we would like to know Xml required to be sent.

We also want to know the period for which trial balance relates to.

Collapse -

by rajeevnadig In reply to how to do vb and tally da ...

Using XMLHTTP you can communicate to Tally 7.2 / Tally 9 for Dataexchange

Collapse -

Using XMLHTTP

by vrushal_mane15 In reply to

Plz can u tell me what would be the URL & port no required for the XMLHTTP object to connect with tally. It would be nice if u could send a sample code

Thanks
Vrushal

Collapse -

by rajeevnadig In reply to how to do vb and tally da ...

Using XMLHTTP you can communicate to Tally 7.2 / Tally 9 for Dataexchange

Back to Desktop Forum
10 total posts (Page 1 of 1)  

Hardware Forums