Python Tally Connector - Method 2 - ODBC using PANDAS

[admin]

Code: Select all

import pyodbc
import warnings
import pandas as pd
import time
from datetime import datetime
import pathlib

import subprocess
import os


warnings.filterwarnings('ignore')

pyodbc.drivers()
import pandas as pd
server = 'localhost,9000'
#database = 'database_name' # enter database name
cnxn = pyodbc.connect('DRIVER={Tally ODBC Driver64};SERVER='+server+';Trusted_Connection=yes;')
cursor = cnxn.cursor()
# select command
query = ''' Select $Name from Ledger'''
data = pd.read_sql(query, cnxn)
data.head()
data.to_csv('file_name1.csv')