Skip to content

Tool to convert CSV data files into MS SQL statements that can be used to populate SQL tables

Notifications You must be signed in to change notification settings

AlexMotz/CSV_MS-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

CSV_MS-SQL

Tool to convert CSV data files into MS SQL statements that can be used to populate SQL tables. Each line of text in the file is read, parsed and converted to SQL and output to stdout (which can be piped).

A table to populate is given by the -t/--table option or by the basename of the input file (if not standard input).

Fields are either given by the -f/--fields option (comma separated) or determined from the first row of data.


Eventually I would like it to sanitize the data it reads from the CSV before writing the SQL import statements. For now a simple find and replace all in your favorite spreadsheet editor does the trick.

About

Tool to convert CSV data files into MS SQL statements that can be used to populate SQL tables

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages