Showing results for Microsoft Access - Scripting Blog [archived]

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 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 handing out copies of Dr. Scripto’s Fun Book, hol...

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 Hey, KB. You know, a few years ago the Scripting Guy who writes this column gave a talk at a conference in Orlando. (And yes, he’ll be back in Orland...

Hey, Scripting Guy! How can I import an Excel spreadsheet into an Access database?-- IE 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 spreadsheet into an Access database, wouldn’t you? Ar...

Hey, Scripting Guy! How can I save a table in an Access database as an Excel spreadsheet?-- OT 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 Jean Ross was busy battling ninja warri...

Hey, Scripting Guy! How can I import a .CSV file into an Office Access database?-- CS 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 his belief that college football is f...