bulk import a folder of csv into sql server, creating tables on the fly

csv_to_sqlserver.ps

#Install-Module dbatools

#In case of scripts are disabled, run first : 
#powershell -noprofile -ExecutionPolicy bypass


import-module dbatools;

Get-ChildItem -Path "C:\CSV_PATH" | ForEach-Object {
    Import-DbaCsv -Csv $_.FullName -SQLInstance "DESKTOP-C5EUKT9" -Database "stagging" -AutoCreateTable
}

# alternative using csvkit is a bit more accurate, but much slower: 

#csvsql --db mssql+pyodbc://servername/databasename?driver=SQL+Server+Native+Client+11.0 --overwrite --insert my.csv