Home » Other » General » Re: Import data from Access to Oracle
Re: Import data from Access to Oracle [message #101795] Fri, 05 October 2001 04:32
Muhammad Sarwar
Messages: 1
Registered: October 2001
Junior Member
First of all convert all data in txt file and make sure that each fields or columns are separated by , and text foramt columns enclosed in ".

Make a file like sqlconv.ctl and start sqlldr.exe from oraclebin area and follow the steps it asks for. When it asks for file, give file name and press enter.

sqlconv.ctl will look like.

LOAD DATA
INFILE 'path and txt file name'
INTO TABLE table name
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

( column 1 ]] column 2 ...) --columns of table file
BEGINDATA

date field like sdate date(20) "dd/mm/yyyy")

that's end

Hope u will understand.

----------------------------------------------------------------------
Previous Topic: Re: Crystal Report for Oracle
Next Topic: Re: problem installing oracle 8i client on windows 2000 professionnal
Goto Forum:
  


Current Time: Thu May 23 14:46:03 CDT 2024