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()
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('Ledger_Names.csv')
print("Data Extracted")