Friday, May 30, 2014

Querying Databases With Powershell

I've been trying to get a PowerShell script to query a MS Database for a couple of weeks and no success. I even ended up having to re-image my computer because I ended up trying to install AccessDatabase_x64.exe on Windows 7 and my script began to work - for a short time. Then Office 2010 stopped working. I think the problem was that my OS is Win7 64-bit but my MS Office 2010 is 32-bit. This broke office. I found the fix by running PowerShell as 32-bit. MS Office processor type must match the version of PowerShell running the script.  This worked just fine! Here are some links that helped me fix this.

ODBC Fails in 64 bit environment - Access MDB
Use ACE Drivers and PowerShell to Talk to Access and Excel
HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"
How to Use Databases from within Windows PowerShell
Using Powershsell to Access SQL Data
Using PowerShell with an MS-Access Database

No comments: