Hi everybody,

I'm wondering if there is a simple way to migrate from Access DB into MySQL?

I open Migration Wizard from my local computer. From the second step in the Wizard I attempt to go to ODBC Data Source, I can select the local Access DB file and add a new ODBC connection to it (as User ODBC). Unfortunately, I see no way to proceed as I'm getting an error and if I look in the log file I'm seeing the following (close to the bottom):

Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration_source_selection.py", line 330, in go_advanced
self.test_connection(self.main.plan.migrationSource, "Source")
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration_source_selection.py", line 255, in test_connection
username = source.connection.parameterValues.userName
KeyError: grt.Dict key must be a string
14:40:36 [INF][ grt]: Connecting to ...
14:40:36 [INF][ grt]: Opening ODBC connection to DSN=MS Access Database...
14:40:36 [ERR][ python]: error calling DbMsAccessRE.connectTraceback (most recent call last):
14:40:36 [ERR][ python]: File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_msaccess_re_grt.py", line 701, in connect
14:40:36 [ERR][ python]: return MsAccessReverseEngineering.connect(connection, password)
14:40:36 [ERR][ python]: File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_msaccess_re_grt.py", line 152, in connect
14:40:36 [ERR][ python]: con = db_driver.connect(connection, password)
14:40:36 [ERR][ python]: File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\db_driver.py", line 95, in connect
14:40:36 [ERR][ python]: connection = library.connect(connection_string, password=password)
14:40:36 [ERR][ python]: pyodbc.Error: ('HY000', 'The driver did not supply an error!')
14:40:36 [ERR][ pymforms]: Unhandled exception in Python code:
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration_source_selection.py", line 330, in go_advanced
self.test_connection(self.main.plan.migrationSource, "Source")
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration_source_selection.py", line 255, in test_connection
username = source.connection.parameterValues.userName
KeyError: grt.Dict key must be a string
---------------------------------------------------------------
If I try to do these steps from the server itself, then that server doesn't have Access driver installed at all - how should I install the driver on that server?

----------------------------
Also, I'd like to import some Excel or csv files as well. I imported one by manually creating the table first. Is there a way to do this for other tables automatically for the files saved locally?

On the server itself there seems to be only drivers for SQL Server and nothing else :(