Discussion Locked

ODBC Connectivity of Tally 7.2 and Excel

0 helpful
10 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

10 replies

by rajkumar.phand

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.

by rajkumar.phand

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.

by rajkumar.phand

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.

by priyanka_kakad2000

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...

by srikrishnathanthri

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

''strRequestXML = _
''"" & _
''"
" & _
''" Export Data" & _
''"
" & _
''" " & _
''" " & _
''" " & _
''" List of Companies" & _
''" " & _
''" $$SysName:XML" & _
''" " & _
''" " & _
''" " & _
''" " & _
''""

''strRequestXML = _
''"" & _
''"
" & _
''" Export Data" & _
''"
" & _
''" " & _
''" " & _
''" " & _
''" trial balance" & _
''" " & _
''" $$SysName:XML" & _
''" " & _
''" " & _
''" " & _
''" " & _
''""

''strRequestXML = _
''"" & _
''"
" & _
''" Export Data" & _
''"
" & _
''" " & _
''" " & _
''" " & _
''" list of accounts" & _
''" " & _
''" $$SysName:XML" & _
''" " & _
''" " & _
''" " & _
''" " & _
''""

''strRequestXML = _
''"" & _
''"
" & _
''" Export Data" & _
''"
" & _
''" " & _
''" " & _
''" " & _
''" Voucher register" & _
''" " & _
''" $$SysName:XML" & _
''" " & _
''" " & _
''" " & _
''" " & _
''""

''strRequestXML = "Export Data
List of Accounts$$SysName:XMLLedgers"

strRequestXML = "Export Data
Trial balance$$SysName:XMLLedgers"

'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.

by vrushal_mane15

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

This discussion is closed to new replies.