I get two kinds of error messages when running Automation and choosing Access Database File as the output format.
Error 1: ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Error 2: ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] Cannot open any more tables.
P.S. Exporting files in Access format works well except for running Automation.
Operating environment: Win 7 Pro SP1 x64, ToadSS 5.7.0.605, Office Professional Plus 2010 x64
I have sent you an email.
And I want to correct what I said previously. In fact, exporting data to Access doesn’t work whether running Automation or not. However, I found that it works fine after I change the language of OS from Chinese Traditional to English. Please help me solve this issue, thank you.