-
Read from file
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
-
Re: Read from file
Originally posted by mooks
Does it work for excel file too?
No, you will have to save Excel as csv for input to sql loader.
Last edited by DaPi; 04-24-2003 at 04:16 AM.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
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
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
-
Thanks everyone!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|