Migrating data from Access to Oracle, how can I load OLE Object to BLOB?

[Anonymous]

Hi all, I need to migrate data from a MS Access table containing OLE objects (some files uploaded to the old Access application are stored in a field in a table) to an Oracle database. I have the same table structure, but in the tAccessInput componenet I don't find any useful datatype.

If I set the datatype to VARCHAR in the input schema, what is moved to the output table is a constant string value ("Long binary or text value").

Any suggestion on how to move the real data?

thanks all in advance

[Anonymous]

Hi josomeda
Take a look at the answers on stackoverflow page.
https://stackoverflow.com/questions/52345849/write-read-ole-object-from-ms-access-to-file-system-wit...
the tAccessxxx components use ODBC driver to access Access DB.

Regards
Shong