Scripting Blog [archived]

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

Microsoft Access - Scripting Blog [archived]

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 ...

How Can I Add the Contents of a Group of Text Files to an Access Database?

May 21, 2007 May 21, 2007 05/21/07
ScriptingGuy1
(image) Hey, Scripting Guy! I have a folder that has hundreds of text files in it. I’d like to take each of those files and add the contents (as a memo field) to an Access database. How can I do that?-- KB(image) (image) (image) Hey, KB. You know, a few years ago the Scripting Guy who writes this column gave a talk at a conference in ...

How Can I Import an Excel Spreadsheet Into an Access Database?

April 4, 2007 Apr 4, 2007 04/4/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I import an Excel spreadsheet into an Access database?-- IE(image) (image) (image) Hey, IE. Wait! Don’t tell us; let us guess. Just a moment … we’re picking up the vibrations now … the sensation is getting stronger and more distinct … OK, got it: you’d like to know how to import an Excel ...

How Can I Save a Table in an Access Database as a Spreadsheet?

April 3, 2007 Apr 3, 2007 04/3/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I save a table in an Access database as an Excel spreadsheet?-- OT(image) (image) (image) Hey, OT. You know, we appreciate the question, but where were you last week, when we really needed you? The truth is, last week was excruciatingly dull, at least for two of the Scripting Guys. While Scripting Guy ...

Hey, Scripting Guy! How Can I Import a .CSV File into an Office Access Database?

February 7, 2007 Feb 7, 2007 02/7/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I import a .CSV file into an Office Access database?-- CS (image) (image) (image) Hey, CS. We’ll get to your question in just a minute. First, though, a few thoughts leftover from Super Bowl XLI: Overall the Scripting Guy who writes this column thought that the game was OK, although it did buttress ...