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..
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: 64152
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
Previous Topic: Rollback in Sql * loader
Next Topic: Encoding Issue on Oracle9i
Goto Forum:
  


Current Time: Sat Dec 10 05:18:23 CST 2016

Total time taken to generate the page: 0.18074 seconds