ActiveX Data Objects (ADO) Archives

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

ScriptingGuy1May 30, 2010May 30, 201005/30/10

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?

ScriptingGuy1August 13, 2009Aug 13, 200908/13/09

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)

ScriptingGuy1April 4, 2009Apr 4, 200904/4/09

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?

ScriptingGuy1September 16, 2008Sep 16, 200809/16/08

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?

ScriptingGuy1September 12, 2008Sep 12, 200809/12/08

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

ActiveX Data Objects (ADO) Archives | Scripting Blog

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

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

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

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

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

PowerShell Resources

Topics

Archive