Export from Access DB to MySQL DB

Asked 2 years ago, Updated 2 years ago, 128 views

You are trying to export from Access DB to MySQL using MySQL ODBC.

Select the table in MS Access, export → ODBC database, and
When you run it,

ODBC - The call failed.
                  Incorrect string value....

appears and cannot be exported.

I think there is something wrong with the character code specification, but I can't find the cause.

The DB character code for Access is SJIS.
MySQL character code is also SJIS. My.ini has the following settings.

[mysql]
default-character-set=sjis

[mysqld]
default-character-set=sjis

Could you please let me know where to fix it?

That's all. Thank you for your cooperation.

mysql ms-access

2022-09-30 18:19

1 Answers

MySQL sjis does not contain the so-called model-dependent characters (such as 」 and 」), which are often used in Windows, so I think it would be better to use cp932 instead of sjis.


2022-09-30 18:19

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.