CSV –> SQL (using PS)

In a recent private project, I have been asked to create a scripted way to import / update data from multiple CSV files (with the same structure, in a folder) to a SQL database.

I am usually not too interested in database work, but I was taken this up, to expand my horizon. My solution (it is about 95% complete now, I would like to find a way to decrease the manual input, such as eliminating the need to have a separate file to store the header; perhaps will update my code in a few days) is based on this excellent post, although I heavily modified it, also the customer had some specific requirements.

Take a look/read on this for further details: fabricesemti80/ImportingCSVsIntoSQLv1 (github.com)

Leave a Reply

Your email address will not be published. Required fields are marked *

Close Bitnami banner
Bitnami