Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

databases - Scripting Blog [archived]

Hey, Scripting Guy! How Can I Add a Record to a Database Using Windows PowerShell?

January 15, 2008 Jan 15, 2008 01/15/08
ScriptingGuy1
(image) Hey, Scripting Guy! Awhile back you showed us how we could use Windows PowerShell to retrieve data from a Microsoft Access database. I’m now trying to add data to a database using PowerShell, but I can’t get the script to work. Any chance you could show me how to add a record to a database using Windows PowerShell?-- AB(image) (...

Hey, Scripting Guy! How Can I Delete a Set of Records From an Access Database?

January 3, 2008 Jan 3, 2008 01/3/08
ScriptingGuy1
(image) Hey, Scripting Guy! We have an Access database that we use to keep track of resources that are associated with all of our projects. Periodically I need to go into the database and delete all the records tied to a particular project. Is there any way that I can do that using a script?-- WK(image) (image) (image) Hey, WK. Having been...

How Can I Find All the Files in a Directory Tree that Contain a Specific Word or Phrase?

August 28, 2007 Aug 28, 2007 08/28/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I find all the files in a directory tree that contain a specified phrase?-- PB (image) (image) (image) Hey, PB. OK, so picture this: for the first time in a couple of months, the Scripting Guy who writes this column and the Scripting Son are playing basketball. The Scripting Son has a comfortable lead, ...

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

July 10, 2007 Jul 10, 2007 07/10/07
ScriptingGuy1
(image) 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 (image) (image) (image) Hey, MF. As you may or may not know, there’s a Microsoft researcher named Gordon Bell who has devoted his ...

How Can I Append a Value to a Specified Field For Each Record in a Database?

June 5, 2007 Jun 5, 2007 06/5/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I add the letter s to the end of a specified field for each record in an Access database?-- A (image) (image) (image) Hey, A. It’s day 2 of TechEd 2007 and the Scripting Guys are still sitting here in the CMP Media booth (that’s booth No. 1301 for those of you attending TechEd); they’re busy ...