As a follow up to my SQLRally 2011 Scripting Guy Guest Blog Post which dealt with Excel and Access files, this post explorers working with delimited text files using the ACE driver. What about Import-CSV? One of the first things I do when working with PowerShell is first look at the built-in cmdlets. PowerShell has…
Tag Archive: ACE
SQLRally 2011 Scripting Guy Guest Blog Post
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…
