GitHub - pftq/CSV-to-SQL: This is a quick application for loading all rows in a CSV (with header columns) into an existing SQL table.

pftq / CSV-to-SQL Public

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

This is a quick application for loading all rows in a CSV (with header columns) into an existing SQL table.

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 3 Commits
CSVToSQL		CSVToSQL
CSVToSQL.exe		CSVToSQL.exe
README.txt		README.txt

Repository files navigation

CSV to SQL
by pftq
https://www.pftq.com/pq/creations/list/CSV_to_SQL/
February 14, 2013

  This is a quick application for loading all rows in a CSV (with header columns) into an existing SQL table.
  
  This was created in C# for a few tasks I needed to get done, but perhaps others out there might also find it useful.
  
Updates
20140601: Updated to replace NaNs with 0s.
20140528: Added batch file loading.  Sped up performance using bulk inserts.