| 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.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
