Ed Wilson (Blog|Twitter) aka Scripting Guy has series of SQL Server related posts the week of May 2nd 2011 including my guest blog post. The post, Use ACE Drivers and PowerShell to Talk to Access and Excel, demonstrates querying Excel and Access files from PowerShell and loading the data into a SQL Server table. There…
Tag Archive: Excel
Using Powershell to Import Excel file into SQL Server
This is a quick script which demonstrates how easy it is to import an Excel file into a SQL Server table using Powershell. The script is posted on PoshCode also: #Change these settings as needed $filepath = ‘G:\PowershellvTSQL\backupset.xlsx’ #Comment/Uncomment connection string based on version #Connection String for Excel 2007: $connString = “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=`”$filepath`”;Extended Properties=`”Excel 12.0 Xml;HDR=YES`”;”…
Send Powershell output to an Excel, PDF, or Image file
While reading through Wrox book, Professional SQL Server 2008 Reporting Services (SSRS) I noticed a chapter on “Integrating Reports Into Custom Applicaiton” where the authors make use of the ReportViewer control to embed an SSRS report in a WinForm application without needing an SSRS server. Since SSRS reports can use DataTables as a data sources I thought this would…
