When trying to import / export table data from / to an Access database file, the following error is given:
"Could not load the Microsoft Access Database Engine. This is not the full Microsoft Access product, just the redistributable engine. It must be the same bit version (32 or 64) as Toad".
The bit version of Toad must match with the Access bit version in order for either the Import or Export to work.
Verifiy the current bit version of Toad and of the Access locally installed. Adjust the installation of Toad or Access as needed.
i.e. 64 bit Toad can only import/export with 64 bit MS Access. And 32 bit Toad will only work with 32 bit MS Access.
Note: If reinstalling Toad to change the bit version, keep in mind that Toad requires an Oracle Client that matches it's bit version also.
i.e. 64 bit Toad can only connect using a 64-bit Oracle client. And similarly 32-bit Toad only connects using a 32-bit Oracle Client.
To check the version and bit of your Toad for Oracle, go to the Help menu | Support Bundle.
