Toad World® Forums

Error occurs when running Automation


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, Office Professional Plus 2010 x64


Can you please post your automation script (tas)? You can send it directly to me ( if you want.




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.