Scripting Blog

A place to learn about PowerShell and share stories of automation

Microsoft Access - Scripting Blog

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

February 19, 2009 Feb 19, 2009 02/19/09
ScriptingGuy1
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 information such...

Hey, Scripting Guy! How Can I Tell Which Tables and Columns Are in a Database Without Opening It?

February 18, 2009 Feb 18, 2009 02/18/09
ScriptingGuy1
Hey, Scripting Guy! Is there a way to figure out which tables and columns are in a database without having to open it up?- DT Hi DT, The Impressionists are back in Chicago! For the past six months, they were hibernating down in Ft. Worth, Texas, in the United States. But now they are back. In true Ferris Bueller style, I am standing here ...

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

February 17, 2009 Feb 17, 2009 02/17/09
ScriptingGuy1
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?

February 16, 2009 Feb 16, 2009 02/16/09
ScriptingGuy1
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! How Can I Import Multiple Worksheets into an Access Database?

January 21, 2008 Jan 21, 2008 01/21/08
ScriptingGuy1
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...