Currently there is no driver that will support writing to MS Access on Mac OS. This is a demonstration on how to write to SQL server. We will read an MS Access table that uses the Cyrillic character set.
1) For “Input File Type” choose “ODBC Data Source”. For “ODBC Data Source” choose the the MS Access file that you preconfigured and tested. See How to Configure MS Access Drivers on Mac OS for instructions.
2) For “Output File Type” choose “ODBC Data Source” For “ODBC Datasource” select the SQL DSN that you previously configured.
3) Click the “Transfer” button, and your data will be transferred.
Use the same process to convert from SQL to Access.