Re: [Import] CSV file

Hi Grzegorz,

There are many ways you could do it. For instance:

o - sql*loader
o - load the csv file in vi and use substitution commands to alter your

    c.s.v into a set of insert statements. o - use windows editor like textpad or ultraedit and use search and

    replace and convert to insert statements. o - use utl_file to read the file and load it o - I have used MS Access before also to something similar, import the

    csv (mouse click) into MS Access and then select into from access to     Oracle
o - many more....

hth,
kind regards

Pete

In article <bp10qf$c34$1_at_news.onet.pl>, Giq <giq_at_poczta.onet.pl> writes
>How to import data from a *.csv file to Oracle9?
>I haven't found it in FAQ.
>
>I tried to use Migration Workbench, but I didn't find it useful for
>importing data (maybe I'm wrong?).
>
>Recently i used DTS from MS SQL Server2000 and it was enough for me (and
>quite simple), but now i have to use Oracle ONLY.
>
>If you have any idea how to do it please share it with me:)
>
>
>--
>Grzegorz 'Giq' Widziszowski
>giq(et)poczta.onet.pl
>gg:1051254
>
>

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.