-
hi all
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
regards
babjee
-
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.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|