DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: loding data from access to oracle

  1. #1
    Join Date
    Feb 2001
    Posts
    6
    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



  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Alternatively use the migration workbench.
    It offers access/ms sql/and sybase migration possibilities.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- 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
  •  


Click Here to Expand Forum to Full Width