I am very new to powershell and I am attempting to import multiple csv files into a SQL database. I have it working if I specify the file but I want to have it import multiple files from a specific folder. The way it's working right now, it will import the one specified file multiple times, based on how many files are in the folder. I've done some digging around and I believe I need to do something like

Set objFSO = CreateObject("Scripting.FileSystemObject")
objStartFolder = "C:\Files"

Set objFolder = objFSO.GetFolder(objStartFolder)
Set Files = objFolder.Files
For each objfile in Files     

and then do the portion that is working below but I am having trouble figuring it out. When I attempted to put the above code in with it I get an error expecting a "(" after "For"

$reportLocation="\\Location\Files\"

$reportname = $reportlocation + "File.csv"

      foreach ($file in Get-ChildItem $reportLocation )

    {   $SqlConnection = New-Object System.Data.SqlClient.SqlConnection
        $SqlConnection.ConnectionString = "Server=ServerName;Database=DatabaseName;Integrated Security=True"
        $SqlConnection.Open()
        $ExecuteDate=(Get-Date -Format s)
        $Today=(Get-Date -Format s)
        $csv = Import-Csv $reportname
        foreach ($line in $csv ) 
        {
            $SqlCmd = New-Object System.Data.SqlClient.SqlCommand
            $SqlCmd.Connection=$SqlConnection
            $newline = $line.'Hour'.split(" ")
            $SqlCmd.CommandText = ("Insert TableName Values('{0}','{1}','{2:hh:mm}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','','$Today','','','','$Today','')" -F
            $line.'TollFree #',                     
            $line.'Date',                       
            [datetime]$newline[0],              
            $newline[1],                        
            $line.'Attempted Calls',                
            $line.'Completed Calls',                
            $line.'Completed MoU',              
            $line.'Incomplete Calls',           
            $line.'Percent Complete',           
            $line.'Busy Calls',                 
            $line.'Percent Busy'                
            )
            $null=$SqlCmd.ExecuteScalar()   
        }
        $SqlConnection.close()
    }

Hopefully I provided enough information. If someone could provide some assitance it would be greatly appreciated!