1 Reply Latest reply: Aug 1, 2013 10:20 AM by Nuno RSS

    msAccess Connection

    Nuno

      Hello


      I am using SqlDeveloper 3.2.20 and need to import a database which was created in msAccess. I do not have Access (or  any MsOffice tool) installed, so the file is exported from some other location and copied to my  laptop.


      Although I have the  "access" tab active in the "create connection" panel, apparently I do not have the proper odbc driver to make the connection, and every time I try to openn the file I get

      java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


      I was trying to find the proper driver and couldn't do it... and  more than once I read that, since msaccess is proprietary, there is  no way I can install it whitout Ofiice...

      My question is: can i get the odbc driver in Oracle downloads, Microsoft site (??), or is it impossible without getting msOffice?


      PS:My environement is W7 64-bit.

       


      Thanks for the help