This project aims to facilitate users in transferring data between Excel files and SQL Server databases using the Python programming language. With this tool, you can easily extract data from Excel files, process it, and save it to the appropriate tables in SQL Server, or vice versa, extract data from SQL Server database and export it to Excel files.
- Exporting Excel Data to SQL Server: You can export data from Excel files to SQL Server databases easily and efficiently. This process allows you to update or upload data into existing tables or automatically create new tables.
- Importing SQL Server Data to Excel: This project also enables you to fetch data from tables in SQL Server databases and export them to Excel files. This is useful for generating reports or analyzing data using familiar spreadsheet tools.
- Support for Various Excel Formats: Additionally, the project supports various Excel file formats, including .xls and .xlsx, so you can easily custom with different Excel versions.
- Microsoft SQL Server 2019
- Python
- Kaggle Dataset [ optional ]
-
Create a Virtual Environtment in your project
python -m venv your_venv_name
You can see Documentation of Python venv in Here.
-
Activate the venv
source ./your_venv_name/Scripts/Activate
-
Install the Required Libraries
pip install your_library_Name
Libraries Version Pyodbc 5.1.0 Pandas 2.2.2 Pyler 2.1.0
Click on this Links
Author : Ganes Yudha Kusuma Copyright : @2024