how to connect the Tally from VB. Is there any ODBC connection in Tally.

[sathikbasha]

hi

Please help me !!!!!!!

how to connect the Tally from VB. Is there any ODBC connection in Tally Software.
I need to import the data from SQL Server to Tally.



regards
SB

[Killer42]

how to connect the Tally from VB. Is there any ODBC connection in Tally Software.
I need to import the data from SQL Server to Tally.

Have you checked out this thread? (The reason for the highlighting in the messages is that I found it by doing a search on "VB TALLY" using the search box up the top.

[QVeen72]

Hi,

First Export Data from SQLServe in "XML" format.
Tally has the option to Import Data from XML Format...

REgards
Veena

[sathikbasha]

Thanks for your reply.

Yes, I already created XML file to import the data.
Now I need to import the data from VB to TALLY.

Waiting for your valuable comments.

[Killer42]

What version of VB are you using? If it's later than VB6, it can probably produce XML fairly easily, so you should be able to import that.

[sathikbasha]

yes i am using VB6.
now i create a sample XML file to insert Data in Tally.
now i need to insert the data into tally

[stcindia]

You can import the XML file from tally Import Data option, if you want to directly push the xml file in tally use XMLHTTP to post the xml into tally webservice server.

[Prakashnaidu1986]

hi,
I know exactly to import with ODBC from tally to excel but i'm not sure about VB, I'll enquire with my friend and check that.
1.Open tally which ever the company u want to import
2.HIT CTRL+N
3.Hit START button and go to RUN option
4.In run option type EXCEL and hit ENTER
5.Excel sheet opens
6.Go to DATA option in standard toolbar
7.Select the option IMPORT EXTERNAL DATA
8.In that sub option select NEW DATABASE QUERY
9.A dialogue box called as CHOOSE DATA SOURCE opens
10.Select TALLY ODBC
11.You will get the options which is created in that respective company, select the required options and import.

[prasanths]

When tally is started a DSN is automatically created in your local system. It is 'TallyODBC_9000' where 9000 is the default port number of Tally Server. You can directly connect to Tally using the connection string 'Dsn=TallyODBC_9000'. Port number 9000 change. When exporting to Excel you can see the fieldnames of data. Use the same fieldnames in queries to access data. Then you can easily connect to Tally in VB 6 or .Net wherever

[rupesh11041963]

http://mirror1.tallysolutions.com/Do...pabilities.pdf

Goto Above.

Will tell you Most of all about the confusions mentioned on this page.

Rupesh
[e-mail]