Feb 24, 2014
PowerShell - Export SQL Data to Excel with Powershell
PowerShell – Export SQL Data to Excel with Powershell
SQL Server Export to Excel with Powershell is very useful for all sorts of activities – ETL and reporting are some examples. This post is to Export SQL Data to Excel with Powershell.In this example, a connection is made to a SQL server Instance using DSN and then SQL output is written to a Excel worksheet. You can also do a Auto refresh of data, Open the Excel Sheet, Go to Data and click…
View On WordPress