Importing data from MYOB to Oracle using ODBC

[Shaun Kerslake]

Hello,

We have an MYOB system file, that we want to import into our Oracle 10g database. I know there is a ODBC Importer option in PL/SQL Developer, but I cannot seem to get it to connect to the file.
Does anyone have any suggestions or experience of this?

Many thanks

 

[Marco Kalter]

Do you have a working MYOB ODBC driver installed on this PC? Can you connect with other ODBC tools?

 

[Shaun Kerslake]

Yes, we are able to load data in MS Access successfully.
At the moment, we are loading data from MYOB -> MS Access -> PL/SQL, however we would like to load all the tables directly from MYOB to PL/SQL Developer.
We are getting an error message "[AnyDAC][Phys][ODBC][odbcmyob] SQL_ERROR"

 

[Shaun Kerslake]

Is there any experience or knowledge as to why the ODBC works for MS Access however I am unable to import tables from MYOB using PL/SQL Developer? Bearing in mind this is using the same ODBC...

I would appreciate any feedback ASAP, as need to migrate the tables into Oracle.

Many thanks