Loading flat file to oracle table?

wwwdavy · #1 (**permalink**) 09-10-03, 21:47

i am oracle beginner

Can anyone tell me how to import a text file or a excel format file into a oracle table...

thank you much

LKBrwn_DBA · #2 (**permalink**) 09-12-03, 12:00

You have to use the sql loader utility.

http://download-west.oracle.com/docs...a90192/toc.htm

For excel, first export the data to a CSV (comma separated values) file, then user sql loader.

wwwdavy · #3 (**permalink**) 09-13-03, 13:18

thx for yr teaching, u really very helpful!

Quote:

Originally posted by LKBrwn_DBA
You have to use the sql loader utility.

http://download-west.oracle.com/docs...a90192/toc.htm

For excel, first export the data to a CSV (comma separated values) file, then user sql loader.

Internet Services

Web Development

Digital Marketing

Consumer Tech