A place to learn about PowerShell and share stories of automation
February 17, 2009Feb 17, 200902/17/09Hey, 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.
February 16, 2009Feb 16, 200902/16/09Hey, 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.
January 31, 2009Jan 31, 200901/31/09How 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,
January 21, 2008Jan 21, 200801/21/08Hey, 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.
January 15, 2008Jan 15, 200801/15/08Hey, 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.
