Scripting Blog [archived]

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

Access.Application - Scripting Blog [archived]

Hey, Scripting Guy! How Can I Import Data into Office Access from Office Excel?

February 19, 2009 Feb 19, 2009 02/19/09
ScriptingGuy1
(image) Hey, Scripting Guy! I need to do hardware inventory on all our workstations and on all our servers. I know System Center Configuration Manager can do this and a whole lot more. We actually have it budgeted for deployment next year. However, that does not help me now. We had a summer intern that went around and typed a lot of ...

Hey, Scripting Guy! How Can I Use Windows PowerShell to Create an Office Access Database?

February 16, 2009 Feb 16, 2009 02/16/09
ScriptingGuy1
(image) Hey, Scripting Guy! I have looked everywhere, and I cannot find a script that will create a new Microsoft Office Access database, and automatically add a new table and columns to it. If you had such a thing in Windows PowerShell it would be even better. I know it is probably too much to ask, but could you, would you write such a ...

How Can I Determine Which Version of Access was Used to Create a Database?

October 7, 2005 Oct 7, 2005 10/7/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I determine which version of Access was used to create an Access database?-- TW(image) (image) (image) Hey, TW. You know, at least one of the Scripting Guys is a bit old-fashioned, to say the least. He doesn’t own a cell phone, and he won’t use drive-through windows. He wears his baseball hat ...