I will automate excel CSV export app using sql and python

Algumas informações são exibidas no idioma inglês.

Bangladesh

Eu falo Inglês

Data Analyst, SQL,Excel and Python Expert, Web Developer

I am a Python developer from Bangladesh with experience in building desktop applications, database management systems, and automation tools. I have hands-on experience with PyQt5, SQL Server, MySQL, a...
Sobre este Serviço

Are you looking for a custom Windows desktop application that connects to your SQL Server database and automates data export to Excel with live refresh functionality?

Look no further!

I will develop a secure and efficient Python-based app tailored to your SQL Server setup.


App Features:

  • Password-protected access
  • ️ Manual database configuration (server, instance, DB name)
  • Test Connection validation
  • Export data to selected folder in Excel format
  • Set auto-refresh interval to keep data updated
  • Runs in the background continuously

Tech Used:

  • Python (Tkinter / PyQt / CustomTkinter for UI)
  • pyodbc / pymssql for SQL Server connection
  • pandas + openpyxl / xlsxwriter for Excel export

Ideal For:

  • Retail POS systems (like CRE)
  • Liquor store inventory/export automation
  • Internal business tools needing live SQL data access

What I Need From You:

  • Sample database/table or structure
  • Data columns you want to export
  • Your preferred UI labels or branding (optional)

Tecnologia:

Excel

Python

Especialidade:

Extração de dados

SQL