Scripting Blog

A place to learn about PowerShell and share stories of automation

How Can I Get a List of the ODBC Drivers that are Installed on a Computer?

Hey, Scripting Guy! How can I get a list of the ODBC drivers that are installed on a computer?-- VV Hey, VV. This is one of those questions that end up driving us crazy. That’s because it: a) seems so simple and, b) appears as though there are a number of ways to get this information. For example, on our Windows XP computer we have no ...

How Can I Tally Items in a Text File?

Hey, Scripting Guy! How can I tally items in a text file?-- JA Hey, JA. If we understand you correctly you have a text file that consists of a number of lines, each line representing a particular item. Just to keep things simple, let’s say your text file consists of city names:City Seattle Seattle Los Angeles Chicago Seattle Los Angeles ...

How Can I Use ADO to Open a Text File That has Spaces in the File Name?

Hey, Scripting Guy! How can I use ADO to open a text file that has spaces in the file name?-- TL Hey, TL. You might not even remember sending us this question; to say it’s been awhile would be an understatement. (You should have seen all the dust and cobwebs we had to brush off this question before we could post it in the Script Center.) ...

How Can I Delete a Table from a Jet Database?

Hey, Scripting Guy! Can I delete a table from a Jet database using a script?-- AK Hey, AK. Of course you can delete a table from a Jet database using a script; after all, you can do anything using a script! Well, OK, maybe not DHCP server stuff. And maybe you can’t change the display resolution of your computer. And maybe not - well, let...