/CSVtoSQLite3

This GitHub repository contains a Python script for automated conversion of CSV data into an SQLite database with automatic data type detection.

Primary LanguagePythonOtherNOASSERTION

CSVtoSQLite3

This GitHub repository contains a Python script for automated conversion of CSV data into an SQLite database with automatic data type detection.

Features:

  • Converts CSV data into an SQLite database.
  • Automatically detects the appropriate data types for each column.
  • Supports both creating a new SQLite database and adding data to an existing one.
  • Easily adaptable to various CSV data structures.

Usage:

  1. Clone this repository to your local machine.

  2. Modify the csv_file_path and sqlite_db_path variables in the script to specify the paths to your CSV file and the desired SQLite database.

  3. Run the script using Python 3.9 or higher.

python csv_to_sqlite.py

  1. The script will create or update the SQLite database with the CSV data.

License:

This project is licensed under the MIT License. See the LICENSE file for details.

Contributors:

Feel free to contribute to this project by creating issues or pull requests.