Scripting Blog [archived]

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

databases - Scripting Blog [archived]

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

June 8, 2006 Jun 8, 2006 06/8/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I list all the tables in an Access database?-- KW(image) (image) (image) 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, dead-ends, and other frustrations we go through in order ...

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

May 4, 2006 May 4, 2006 05/4/06
ScriptingGuy1
(image) 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(image) (image) (image) Hey, TW. You know, in your email you sort of apologized for using text files, noting that “...

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

April 6, 2006 Apr 6, 2006 04/6/06
ScriptingGuy1
(image) Hey, Scripting Guy! In an Excel spreadsheet, how can I locate and replace information for a specific computer?-- BB(image) (image) (image) 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 Guys have at the moment is some code for ...

How Can I Use ADO to Read a Text File Where All the Data is on a Single Line?

November 15, 2005 Nov 15, 2005 11/15/05
ScriptingGuy1
(image) Hey, Scripting Guy! I have a fixed-width text file which includes first name (6 characters), last name (13 characters), and department (9 characters) all on a single line. How do I read that using ADO?-- DW(image) (image) (image) Hey, DW. Well, to be perfectly honest, we don’t think you can read a file like this using ADO (...