When I try to export a dataset to Microsoft access, I get the attached error. Export to Microsoft Excel works fine (if it was a 64-bit thing, I would expect Excel to fail, too; they are the same Office Package). I’m running 64-bit TOAD version 220.127.116.11; but this error has happened since 64-bit TOAD first came out. How can I get export to Microsoft Access to work? The work around mentioned on TOAD World, using a different file extension, fails: http://www.toadworld.com/products/toad-for-oracle/f/10/t/21214.aspx?Redirected=true
(John Dorlon / 30 Jan 2014 at 2:22pm
This was recently discovered and it is fixed in beta.
As a workaround, if you export with the .accdb extension instead of .mdb, it will work.
Access_error_from_TOAD.docx (23 KB)