Import Excel File Into Sql Server Table Using Powershell

Here is an example of how to import Excel data or csv file into SQL Server table (with header) using Powershell script.

#download ACE.pcm1 module nad save it in C:\Windows\System32\WindowsPowerShell\v1.0\Modules\ACE
 
Import-module ACE
 
#download *.ps1 fiels from the list below and save in in your Powershell folder 
 
#. "K:\Powershell\System\Invoke-SqlCmd2.ps1"
#. "K:\Powershell\System\Write-DataTable.ps1"
#. "K:\Powershell\System\Add-SqlTable.ps1"
#. "K:\Powershell\System\Initialize-SqlpsEnvironment.ps1"
 
    $ds= Get-ACEData -FilePath C:\temp\alex.xlsx -Table 'Sheet1$'
    Add-SqlTable -ServerInstance "PC825\SQL2008" -Database DBA -TableName $($ds.Tables[0].TableName) -DataTable $ds.Tables[0]
    Write-DataTable -ServerInstance "PC825\SQL2008" -Database DBA -TableName $($ds.Tables[0].TableName) -Data $ds.Tables[0]
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License