As Technet Gallery is retiring so moving the code to Git Hub. (click below github download link for this script)

Import from CSV to SQL Table

 

Hi All,

Sharing a Powershell method to import CSV to sql table, I am attaching the example CSV as well.

First step is to create the Header in SQL table same as in CSV that needs to be Imported.

I am sharing the example that I have followed for demonstration of this script:

• Created the Test Database by logging in to SQL management studio

Tech Wizard

https://techwizard.cloud

https://syscloudpro.com/

PowerShell Cheat Book