Archives: May 2011
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… Read more
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… Read more