VB.NET - Getting Data from Tally to SQL Server

Asked By Sini S on 07-Dec-09 03:36 AM

Hi,
I want to get the data from tally to sql server and with VB.net, 
I want to display these data to user. How can I do this? Pls help me...

Sini

check this

Santhosh N replied to Sini S on 07-Dec-09 03:43 AM

this thread should put you in right direction on how to access tally data from sql server and what are the limitataions..

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/c6895b23-06fb-4cce-a06d-5bd2c7566566

Import TALLY Data / Export TALLY Data

Venkat K replied to Sini S on 07-Dec-09 03:47 AM

Tally 9 has an option to export tally data to excel using ODBC

1. Export data from Tally to Excel using ODBC.

2. Export data from excel to sql server.

Process:

Tally allows users to Import data from other software's as well as Export data from Tally to other software's. Tally allows users to Import and Export in ASCII, SDF and XML formats. XML is now the most widely used format of exporting data in the world. Any transactions can be exported from Tally and imported in other software after suitably altering the current structures to accept Tally data structure. The reverse is also possible by writing a small TDL program to accept the data from other software's. The data that is to be imported into Tally can be in either XML or DBF format. Easy Tally data transfer or Tally data migration from Tally 4.5 & Tally 5.4 to Tally 6.3 , Tally 7.2 , etc.

ODBC COMPLIANCE ALLOWS OTHER PROGRAMS TO USE DATA FROM TALLY DIRECTLY. E.G. : MS-EXCEL :
ODBC - OPEN DATABASE CONNECTIVITY

Tally is now ODBC compliant. Hence, any program like MS-Excel, Oracle etc that is ODBC compliant can use data from Tally. Here, data connectivity is dynamic i.e. any new updation in Tally is reflected in other ODBC Compliant Software immediately. Now, with ODBC facility the user can extract data out of Tally and design his own report formats in other ODBC compliant software's.

Procedure :

Now, Load Company -> specify period -> minimize Tally -> Open a new Excel file -> select data -> select 'Get External Data' -> select New database query -> choose Data Source

Tally connects to data source and displays Tally Wizard query screen -> select the columns you would want to include in the query.

Once all the columns are selected, the user returns to excel and excel displays all the columns selected

Method 2:

You can also use third-party dll to export data.

TallyMig is a software utility which allows you to Import data into Tally Accounting Software. It supports Import of data from various sources like Excel, SQL-Server, MySQL, Access, DBase, Foxpro, Visual Foxpro DBF's and several other database formats.

check this link for more info:

http://www.rksolution.co.in/dataconn.aspx

Thanks,

Pls clarify

Sini S replied to Venkat K on 07-Dec-09 03:54 AM

Thank you very much for ur reply.

From where I can download TallyODBC?

Can I connect to sql server with this TallyODBC?

Sini

Exporting data from Tally

mv ark replied to Sini S on 07-Dec-09 04:28 AM

Check these links -

Exporting data from Tally -  http://apnitally.blogspot.com/2006/09/exporting-data-from-tally-quick.html

RTSlink is a Dynamic Link Library (DLL) that facilitates exchange of data between Tally and your Application - http://www.rtslink.com/index.html

Linking your Software with Tally - http://www.rtslink.blogspot.com/2007_02_01_archive.html#7326983865496340815

Great help

Sini S replied to mv ark on 07-Dec-09 04:49 AM

Thank you Very much.... It is a great help.

But what I need is a vb.net form from where I can fetch the data from Tally and display it to the users.
Tally people (finance dept) will not do any Export/Import. with my Read-only permission, I have to get that data to my VB.Net application.

Thanks in advance...

Sini

Parivesh replied to Sini S on 07-Dec-10 12:46 AM

Hi Sini,

myself Parivesh Trivedi. looking for a solution same like u. i want to show tally data in my VB6 application. did u get any solution for this, please help me in this i'll be very thankful to you. my mail id is parivesh.trivedi@gmail.com

Thanks in Advance...

Parivesh Trivedi

Rajeev Singh replied to Sini S on 19-Jan-11 11:57 AM

You can get data from Tally ERP 9 into SQL Server or any other database using the DX-Fusion Free Edition.

Refer this link http://rtslink.com/dx-fusion/getting-data-from-tally-into-sql-server.html

Tally 2SQL replied to Sini S on 15-Nov-11 08:33 PM

This utility uses xml for conversion of tally data into SQL Server. The utility details are available at audit-n-certify.com