Metadata-Version: 2.1
Name: load-for-database
Version: 0.3.0
Summary: Function to load data from XLSX files to a SQL Server database
Home-page: https://github.com/Bononi48/load_for_database.git
Author: Lucas Bononi
Author-email: contatobononi@gmail.com
License: UNKNOWN
Platform: UNKNOWN
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.6
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: pandas
Requires-Dist: sqlalchemy
Requires-Dist: pyodbc
Requires-Dist: openpyxl

    """
    Loads data from an XLSX file into a table in a SQL Server database.

    parameters:
    - path_folder: Path to the folder where the XLSX file is located.
    - file_name: Name of the XLSX file to be loaded.
    - table_name: Name of the target table in the database.
    - schema: Schema of the table in the database.
    - server: Name or address of the SQL server.
    - database: Name of the database.
    - user: Username for connecting to the database.
    - password: Password for connecting to the database.
    - driver: (Opcional) Driver ODBC a ser utilizado. PadrÃ£o: "ODBC Driver 17 for SQL Server".
    """

