Explorar las categorías
Explora
Fiverr Pro
Español
$
USD
I will automate excel CSV export app using sql and python
Expert in SQL, Excel, Python & HTML. I provide data analysis, automation, custom scripts, dashboards, and responsive web design. Quality work, fast delivery, and clear communication.
Acerca de este Servicio
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)
Tecnología:
Excel
•
Python
Experiencia:
Extracción de Datos
•
SQL
FAQ
Will the app work with my existing SQL Server database?
Yes! You just need to provide the server details, DB name, and login. The app will connect using those.
Can I choose where to save the exported Excel file?
Absolutely! The app lets you browse and choose your preferred folder.
Will it auto-refresh data from the database?
Yes. You can set a time interval (in seconds), and the app will keep updating the Excel file automatically.
Can you add company branding or a custom installer?
Yes, I offer branding, icons, splash screen, and an installable EXE in the Premium package.
