roskakori / cutplace

validate data stored in CSV, PRN, ODS or Excel files
http://cutplace.readthedocs.org/
GNU Lesser General Public License v3.0
18 stars 20 forks source link

Add option to build T/SQL bulk insert statements #101

Open roskakori opened 9 years ago

roskakori commented 9 years ago

Goal: cutplace --sql bulk_insert some_cid.ods data.csv creates a T/SQL bulk insert statement to insert data.csv into a table described by some_cid.ods.

bulk insert documentation: https://msdn.microsoft.com/en-us/library/ms188365.aspx