Huseyin ABANOZ

Since Microsoft does not provide 64 bit drivers for Access; it becomes a nuisance to access MS Access under 64 bit platforms.   For a successfull connection to  MS Access DB File (*.mdb)  with  JDBC  under 64 bit platforms, follow following steps: 1-        Make sure Access drivers are installed. If access is installed it is already there, else download from  this  link and install. 2-        Configure  Data Source Name  using 32 bit  ODBC Data Source Administrator . Use the executable at c:\windows\sysWOW64\odbcad32.exe. 3-        System DSN->Add->Microsoft Access Driver (*.mdb) -            Specify a Data Source Name -            Specify a description -            L...

To export an access database ( mda  file) to  MySQL  database is quiet easy. All needed is to download 32 bit  MySQL Connector/ODBC  driver  from  http://dev.mysql.com/downloads/connector/odbc/  and follow steps below. 1-      Select the table to export. 2-      From  External Data  tab select  ODBC Database . See picture below. Picture  1  ODBC Database Export 3-        Specify table name to export onto. Typically the same name as the access table name. 4-         From  Select Data Source  dialog select  Machine Data Source  tab and click  new. Picture  2  MySql OBDC Driver 5-        Select  MySQL Connector/ODBC  driver   from list. Click OK.   6-        Specify co...