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

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

Justin Dearing — Thu, 25 Aug 2011 11:49:25 GMT

That's a great script. Personally I am not a fan of doing COM interop with Office if it is avoidable. Its high overhead. I wrote a blog post on how to create an Access Database with Powershell without Access installed (www.justaprogrammer.net/.../creating-an-access-database-in-powershell-without-access-installed). I had a few headaches getting there, but it works pretty good now.

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

Hitchheik@hotmail.com — Tue, 21 Dec 2010 02:32:19 GMT

# *** Needed for 64-bit computer to make/update table in Access ***

$erroractionpreference = "SilentlyContinue"

if ($env:Processor_Architecture -ne "x86")

{

write-warning "Running x86 PowerShell..."

&"$env:WINDIR\syswow64\windowspowershell\v1.0\powershell.exe" -NonInteractive -noprofile -file $myinvocation.Mycommand.path -executionpolicy bypass

exit

}

# *** Entry Point to Script ***