Toad World® Forums

Error when exporting from oracle to access


I’m getting an error when trying to import data to ms access which was exported from oracle before.

ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] Cannot open any more tables

Toad Data Point

MS Access 2007

when trying it manually, sometimes everything is o.k., but with automation it allways failes.

Has anyone an idea?


Could you send us the automation (.tas) and the export (.txp) files, along with the error log generated from the automation when the error happens?