GitHub - rm-richard/excel-to-sql: Node.js script to convert excel files into INSERT or UPDATE statements

rm-richard / excel-to-sql Public

Notifications You must be signed in to change notification settings
Fork 4
Star 2

Node.js script to convert excel files into INSERT or UPDATE statements

2 stars 4 forks Branches Tags Activity

Name		Name	Last commit message	Last commit date
Latest commit History 2 Commits
.gitignore		.gitignore
README.md		README.md
index.js		index.js
package.json		package.json
test.xls		test.xls

Repository files navigation

excel-to-sql

Node.js script to convert .xls and .xlsx files into INSERT or UPDATE statements.

Install and run

$ npm install
$ node index.js

Prompts

Source excel file
Target .sql filename
Target [schema].table
What type of statement to generate? INSERT / UPDATE
Header title of the Primary Key column? (only if UPDATE was chosen)

License

MIT