none
Powershell and Microsoft Access 2013 Provider can not be found RRS feed

  • Question

  • Hi Guys:

    I am trying to recover some data from a Microsoft Access 2013 file (.accdb) with powershell. I attempt the following code for the connection

    $objConnection = New-Object -ComObject ADODB.Connection
    $objConnection.Open("Provider=Microsoft.Jet.OLEDB.12.0;Data Source=$($strDatabase)")

    but when I run it I get the following error: Provider cannot be found. It may not be properly installed.

    I downloaded Microsoft Access database engine 2010 but the error persist. Also I tried to run it in 32bits with C:\WINDOWS\SysWOW64\WindowsPowerShell\v1.0\powershell.exe but nothing changes.

    Do you have any idea what could be missing?

    Wednesday, November 30, 2016 6:32 PM

Answers

  • Jet no longer exists.  You have to use the ACE drivers.

    "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\test\mydata.accdb"


    \_(ツ)_/

    Wednesday, November 30, 2016 6:45 PM

All replies

  • Jet no longer exists.  You have to use the ACE drivers.

    "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\test\mydata.accdb"


    \_(ツ)_/

    Wednesday, November 30, 2016 6:45 PM
  • Thanks a lot for your help. I was able to get the data I needed with it.
    Wednesday, November 30, 2016 8:55 PM