64-bit TOAD error export to Microsoft Access

Toad for Oracle - Beta
1

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 12.7.0.73; 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.

)

Larry

703-508-4945
Access_error_from_TOAD.docx (23 KB)

2

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.