ActiveX Data Objects (ADO)

Hey, Scripting Guy! Weekend Scripter: Using the Windows Search Index to Find Specific Files

May 30, 2010 May 30, 2010 05/30/10

ScriptingGuy1

Microsoft Scripting Guy Ed Wilson here. One of the cool things about using Windows PowerShell is the different objects with which you can interact. Windows Search is an example of this. By using ADO, you can query the Windows Search index and retrieve information about files. This technique can have some very interesting possibilities...

Hey, Scripting Guy! Can I Query a Microsoft Access Database with a Windows PowerShell Script?

August 13, 2009 Aug 13, 2009 08/13/09

ScriptingGuy1

Hey Scripting Guy! I have a Microsoft Access database that I need to query from a Windows PowerShell script. I have seen a number of VBScript examples, but I cannot find any Windows PowerShell samples. Can you point me in the right direction? I do not want you to write it for me, but I would like a hint.-- KS Hello KS, Microsoft ...

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (04/03/09)

April 4, 2009 Apr 4, 2009 04/4/09

ScriptingGuy1

Troubleshooting the Application of Two WMI Classes Hey, Scripting Guy! The examples produced from the "Scriptomatic Version 2.0 by The Microsoft Scripting Guys" for the entries Win32_ServiceSpecification and Win32_ServiceControl both return error 0x80041002 under Windows Server 2003. I can't find another WMI class that exposes the ...

Hey, Scripting Guy! How Can I Write to Excel Without Using Excel?

September 16, 2008 Sep 16, 2008 09/16/08

ScriptingGuy1

Hey, Scripting Guy! I need to be able to write information to an Excel file. I do not want to install Microsoft Office Excel on my server, but the spreadsheet format is a nice way to store information. I can then give it to my pointy-headed boss, and he can create pivot tables, charts, or whatever exactly it is he does all day. Basically, ...

Hey, Scripting Guy! How Can I Read from Excel Without Using Excel?

September 12, 2008 Sep 12, 2008 09/12/08

ScriptingGuy1

Hey, Scripting Guy! I have an Microsoft Office Excel spreadsheet with server names in it, and I would like to be able to use this in a Windows PowerShell script. The thing is, I do not have Microsoft Office or Excel installed on the server. How can I use this spread sheet without installing Office on my server (which I understand is ...

Scripting Blog