search

gitdagray / csv-to-sql-insert

Provide table data as a CSV (comma-separated values) file and output a SQL insert statement for a table with the same name as the file.
MIT License
97 stars 122 forks source link
csv csv-converter csv-files csv-import csv-parser csv-parsing csv-reading sql sql-insert sql-insert-queries sql-insert-statements

readme

csv-to-sql-insert

Provide table data as a CSV (comma-separated values) file and output a SQL insert statement for a table with the same name as the file.

Usage ⚙

  1. Confirm you have a directory named csv
  2. Confirm you have a directory named sql
  3. Save your input CSV file in the csv directory
  4. In a terminal window, first run npm install to install dependencies and then run npm start YourFileName
  5. Watch the terminal window for any error messages
  6. Your SQL insert statement will be saved in sql/YourFileName.sql

Support 👨‍💻

Contributing 🛠

Please read CONTRIBUTING.md prior to contributing.

Code of Conduct

Please see CODE_OF_CONDUCT.md.