64-bit TOAD error export to Microsoft Access

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; 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)

Export to Access requires the same bitness as Toad. Exporting to Excel does not require the same bitness, due to differences in the mechanics of these two exports.