Microsoft Access

Hey, Scripting Guy! How Can I Create a Database with More Than One Table?

ScriptingGuy1 February 17, 2009 Feb 17, 2009 02/17/09

Hey, Scripting Guy! Being able to create a database from a script is nice, and I appreciated your article yesterday. But I need to have a database with more than one table in it. Obviously this can be done, but I am at a loss as to how to go about it. I am not a real programmer; do you have any tips for me?.- GF Hi GF, You need to do what? ...

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

ScriptingGuy1 February 16, 2009 Feb 16, 2009 02/16/09

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 thing for me...

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (01/30/09)

ScriptingGuy1 January 31, 2009 Jan 31, 2009 01/31/09

How Do I Compress Files? Hey, Scripting Guy! After some time without needing help, I've run into a problem about which I have been unable to discover any information. Perhaps you can aid me. Assume you have (1) a single file, and (2) a folder that contains a number of files of various types. Further assume that you wish to store those ...

Hey, Scripting Guy! How Can I Import Multiple Worksheets into an Access Database?

ScriptingGuy1 January 21, 2008 Jan 21, 2008 01/21/08

Hey, Scripting Guy! I’m trying to import a spreadsheet into an Access database. The problem is that the spreadsheet has multiple worksheets. I can import the first worksheet without any problem, but I can’t figure out how to import all the other worksheets in the file. How can I import multiple worksheets into an Access database...

Hey, Scripting Guy! How Can I Add a Record to a Database Using Windows PowerShell?

ScriptingGuy1 January 15, 2008 Jan 15, 2008 01/15/08

Hey, Scripting Guy! Awhile back you showed us how we could use Windows PowerShell to retrieve data from a Microsoft Access database. I’m now trying to add data to a database using PowerShell, but I can’t get the script to work. Any chance you could show me how to add a record to a database using Windows PowerShell?-- AB Hey, AB. Before ...

Scripting Blog

Microsoft Access - Scripting Blog

Hey, Scripting Guy! How Can I Create a Database with More Than One Table?

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

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (01/30/09)

Hey, Scripting Guy! How Can I Import Multiple Worksheets into an Access Database?

Hey, Scripting Guy! How Can I Add a Record to a Database Using Windows PowerShell?

PowerShell Resources

Topics

Archive