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

Naomi,

For this and for the other related Access to MySql questions, have you tried Bullzip's migrator?

https://www.bullzip.com/products/a2m/info.php



>
>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 :(