Home » SQL & PL/SQL » Client Tools » Need to load XLS file into Database
Need to load XLS file into Database [message #349209] Fri, 19 September 2008 06:04 Go to next message
atozvs
Messages: 12
Registered: May 2008
Location: Hyderabad
Junior Member
Hi,

I wanted to load the data into a table from an XLS sheet with multiple datasheets.

can any one suggest hoe to get this.

regards
vs
Re: Need to load XLS file into Database [message #349227 is a reply to message #349209] Fri, 19 September 2008 06:50 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One way would be to create a CSV file for each worksheet and load their contents into an Oracle database via SQL*Loader or external tables feature.
Re: Need to load XLS file into Database [message #349261 is a reply to message #349209] Fri, 19 September 2008 09:45 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Another way is to use oracle Heterogeneous Services

Setup and config details are available here

This will let you access the contents of the Spreadsheet as though each datasheet were a table.
Re: Need to load XLS file into Database [message #349875 is a reply to message #349261] Tue, 23 September 2008 06:40 Go to previous messageGo to next message
atozvs
Messages: 12
Registered: May 2008
Location: Hyderabad
Junior Member
I really cant open each sheet individually to convert into .csv as i have around 80 Data sheets in the Excel sheet.

Can I have a simpler solution for loading this data into oracle DB or SQL Server DB.

Thanks
VS
Re: Need to load XLS file into Database [message #349899 is a reply to message #349875] Tue, 23 September 2008 07:38 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What about JRowbottom's suggestion? Did you check the link?
Previous Topic: How to open excel file from Oracle Application Unix form Server
Next Topic: cannot see code for procedures
Goto Forum:
  


Current Time: Fri Dec 09 05:35:17 CST 2016

Total time taken to generate the page: 0.19114 seconds