Hi
If i have a text file with columns like student id, register date seperated by comma, how do i import it into a table in oracle? Is there a limit on the size of the file? Does it work for excel file too?
Thanks!
Printable View
Hi
If i have a text file with columns like student id, register date seperated by comma, how do i import it into a table in oracle? Is there a limit on the size of the file? Does it work for excel file too?
Thanks!
you can use sql loader, utl_file, csv, odbc etc
if i´s plain text sql loader would be the fastest way
No, you will have to save Excel as csv for input to sql loader.Quote:
Originally posted by mooks
Does it work for excel file too?
Is there any example or references i can read on?
It's in the Server Utilities manual in the Oracle doc, also on http://download-west.oracle.com/docs...6955/part2.htm
Hi
Have a look here
http://otn.oracle.com/pls/tahiti/tah...loader+#a76955
regards
Hrishy
Thanks everyone! ;)