/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.

Primary LanguageTypeScriptMIT LicenseMIT

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.