| excel and Oracle Tables [message #158294] |
Thu, 09 February 2006 14:51  |
rkl1
Messages: 97
Registered: June 2005
|
Member |
|
|
Dear All,
Once a while, I get an excel spread sheet and need to put the data into oracle tables. What is the best way to accomplish it.
Here the way I use:
1.create insert statements from the excel data and then paste into a txt file to run against oracle. Takes some time to work it out.
2. Use toad to create a control file to load excel data to oracle tables. You need to save the excel first into a csv format for sql*loader to load it.
Is there any other tool or technique to work out better between excel and oracle.
Thanks.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
