I've been trying to migrate the data. I've even tried the Northwind and it succeeded. The problem now is, the Tools->Migration->Microsoft Access Exporter (MS Access 2000 exporter) doesn't export the entire data from tables. I've some 20 records in one table and it exported only 6. There are few tables which don't get any data exported at all. The message shows export completed successfully.
I'm using SQL Developer 3.2. Please help.
To try and get some idea of why you have problems what happenms if you try the following for one of the tables that gives the problem -
- export - do all the rows get put into the export file ?
- copy to Oracle - does this copy all the rows or give any errors /