Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » ActiveX Data Objects (ADO)   (RSS)
Thursday, August 13, 2009 12:01 AM

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

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
Posted by ScriptingGuy | 0 Comments
Friday, April 03, 2009 9:38 PM

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (04/03/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
Posted by ScriptingGuy | 0 Comments
Monday, September 15, 2008 11:24 PM

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

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
Posted by ScriptingGuy | 0 Comments
Thursday, September 11, 2008 11:23 PM

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

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
Posted by ScriptingGuy | 1 Comments
Monday, July 09, 2007 9:38 PM

How Can I List All the Fields and Data Types in an Access Database?

Hey, Scripting Guy! In a previous column you showed us how to list all the tables in an Access database. How can I list all the fields in those tables, along with the data type of each field? -- MF Hey, MF. As you may or may not know, there’s a Microsoft
Posted by ScriptingGuy | 0 Comments
Friday, December 15, 2006 8:55 AM

How Can I List All the Access Database Files on a Computer?

Hey, Scripting Guy! How can I list all the Access database files (.mdb and .ldb files) on a computer? -- MG Hey, MG. You know, in this day and age most people don’t believe in Santa Claus. Well, we happen to know that these people are wrong: Santa Claus
Posted by ScriptingGuy | 0 Comments
Monday, November 20, 2006 11:15 AM

How Can I Add a User to a Group If I Don’t Know the Distinguished Name of That User?

Hey, Scripting Guy! How can I add a user to an Active Directory group if I don’t know the distinguished name of that user? -- VO Hey, VO. You know, if we wanted to take the easy way out here we’d just tell you, “Sorry, but if you don’t know the distinguished
Posted by ScriptingGuy | 1 Comments
Monday, October 16, 2006 6:44 PM

How Can I Create a Table in a SQL Server Database?

Hey, Scripting Guy! How can I create a table in a SQL Server database? -- FD Hey, FD. And thanks: you’ve saved the Scripting Guys! Or, at any rate, you’ve saved the Scripting Guy who writes this column. As it turns out, this Scripting Guy is getting ready
Posted by ScriptingGuy | 0 Comments
Wednesday, October 11, 2006 8:45 AM

How Can I Delete a Record From a Disconnected Recordset?

Hey, Scripting Guy! How can I delete a record – or a set of records – from a disconnected recordset? -- SM eHy sm.,. Sorry; let’s try that again: Hey, SM. We apologize for the poor typing the first time around; the Scripting Guy who writes this column
Posted by ScriptingGuy | 0 Comments
Monday, October 02, 2006 11:30 AM

How Can I Use Windows PowerShell to Pull Records From a Microsoft Access Database?

Hey, Scripting Guy! How can I use Windows PowerShell to pull records from a Microsoft Access database? -- SB Hey, SB. You know, you’re lucky to get this question answered; after all, this looks as though it’s going to be the very last Hey, Scripting Guy!
Posted by ScriptingGuy | 0 Comments
Thursday, September 14, 2006 11:58 AM

How Can I Get a List of All the Databases on a SQL Server Computer?

Hey, Scripting Guy! How can I get a list of all the databases on a SQL Server computer? -- ER Hey, ER. Before we answer your question, we’d like to take a moment to offer our opinions on all the major – and controversial – issues of the day. We can do
Posted by ScriptingGuy | 0 Comments
Tuesday, June 13, 2006 1:13 PM

How Can I Populate a List Box With the CNs of All the OUs in My Domain?

Hey, Scripting Guy! How can I populate a list box with the CNs of all the OUs in my domain? -- AK Hey, AK. That’s an interesting question, AK, and we’ll do our best to answer it. Of course, we should point out that the United States soccer team has just
Posted by ScriptingGuy | 0 Comments
Thursday, June 08, 2006 6:20 AM

How Can I List All the Tables in an Access Database?

Hey, Scripting Guy! How can I list all the tables in an Access database? -- KW Hey, KW. You know, the best part about writing a daily column on system administration scripting is that people only see the finished result; they never see all the detours,
Posted by ScriptingGuy | 0 Comments
Thursday, May 04, 2006 7:02 AM

How Can I Query a Text File and Retrieve Records That Occurred on a Specific Date?

Hey, Scripting Guy! We have tons of text files in which each line in the file represents a record or an event of some kind. How can I use a script to retrieve records or events that occurred on a specified date? -- TW Hey, TW. You know, in your email
Posted by ScriptingGuy | 1 Comments
Thursday, April 06, 2006 7:15 AM

How Can I Locate and Replace Information for a Specific Item in a Spreadsheet?

Hey, Scripting Guy! In an Excel spreadsheet, how can I locate and replace information for a specific computer? -- BB Hey, BB. You know, there’s an old saying that goes, “If all you have is a hammer then everything looks like a nail.” Well, all we Scripting
Posted by ScriptingGuy | 0 Comments
More Posts Next page »
 
Page view tracker