0
$\begingroup$

Clearly I don't know what I'm doing. Before I retired I had to access MS SQL databases. Now I am trying to use MS Access. Most of what I found on the web is 8-10 years old, and possibly that's why I'm having a problem.

I'm connecting using

  JDBC["Microsoft Access(ODBC)", 
   "Y:/myFolder/data one.accdb"]];

I get an error telling me JDBC::ClassNotFound.

I'd appreciate some help.

Improve this question
$\endgroup$
1
  • $\begingroup$ Following works fine in Mathematica (14.2) and Microsoft® Access® for Microsoft 365 MSO (Version 2503 Build 16.0.18623.20116) 64-bit): conn = OpenSQLConnection[JDBC["Microsoft Access(UCanAccess)", accdbPath]] $\endgroup$ Commented Apr 13 at 15:35

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.