Home » RDBMS Server » Server Utilities » need to load data from different sheets of the same xl file (need to load data from different sheets of the same xl file)
need to load data from different sheets of the same xl file [message #274284] Mon, 15 October 2007 06:23 Go to next message
kool010
Messages: 1
Registered: October 2007
Junior Member
Is there any method to load data from the different sheets of an excel sheet into tables?using sql loader or utl_file or by other means??
If yes, please let me know te details of the same.
Thanks in advance..

Report message to a moderator

Re: need to load data from different sheets of the same xl file [message #274286 is a reply to message #274284] Mon, 15 October 2007 06:38 Go to previous message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- Save each sheet into a csv file and use SQL*Loader or external tables
- Use obdc and VBA program

Regards
Michel

Report message to a moderator

Previous Topic: Rollback in Sql * loader
Next Topic: Encoding Issue on Oracle9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 26 13:52:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.