I am using Oracle SQL Developer 4.0 and Ms Access 2013 under Windows 7 (64 bits)
After browsing and selecting MS Access file with accdb extention, I got an error message :[Microsoft] " Data source name not found and no default driver specified".
On Administravitve Tools=> ODBC Data Source Administrator=>Drivers I have File date
Name : Version
Microsoft Acess Driver (*.mdb, *accdb) 12.00.4518.1014 ACEODBC.DLL 26/10/2006
Would you please advise?
Thank you very much in advance
That MS Access driver is 64-bit, I think. If SQL Developer, or JDK is 32-bit you need to use the 32-bit driver. You can see if you have a 32-bit driver installed using c:\windows\system32\odbcadm32.exe