We need to add the -Header argument to Import-Csv and give it dummy column names. The actual column names in the datatable are now determined from the table...

@bruin - here you go. It's somewhat longer now but does type checking and (optionally with command line switch) char column width 

param
(

Hi Bruin
If you and others are interested, I'll develop a full-fat version of this and post it later.

The PowerShell built-in cmdlet Import-Csv handles all the nonsense of commas within the quoted strings very nicely for us.
Try this for size.

• Import-Csv returns PowerShell objects, one...

Much simpler and more efficient version (only one round-trip to the SQL server).
If you wanted to update the table with the current state, the valueList could be used to...

Killing connections like that reminds me of my Sybase days!

How about a one liner?

ALTER DATABASE [dbname] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

That will drop all user connections apart from your own....