our company wants to load data from access to oracle database. my tables have many valume of data. how can i split and convert into csv file. pls help me
Why don't you just link in the relevant tables with an ODBC driver and then write an insert action query to populate data in your database. You will need to move the data in parent child order. Otherwise you can use Access to export the data into files, one table per file and then use sql loader to load the data.
Alternatively use the migration workbench.
It offers access/ms sql/and sybase migration possibilities.
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be
Click Here to Expand Forum to Full Width