BTW,

I'm not the only one with that problem, I found the same bug in MySQL bugs - wondering if the team is going to provide an official fix since I don't think I should be trying changing python files myself

https://bugs.mysql.com/bug.php?id=87647&thanks=3¬ify=195

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