Home » RDBMS Server » Server Utilities » Loading Multiples excel files to multiple tables (Oracle 11g)
Loading Multiples excel files to multiple tables [message #549357] Thu, 29 March 2012 15:49 Go to next message
gentleman777us
Messages: 122
Registered: April 2005
Senior Member
Hi,

I have a bunch of data in 50 excel files. I need to load all these 50 files into 50 different tables. I would like to do this in one script. I went through the forum to get this information, people suggested create a shell script etc or list the sqlldr command multiple times etc.

Can someone provide some clarity on this as to what's the best approach.If it is through shell scripting can someone provide the shell script and instructions to execute it. Iam new to shell scripting.

Your prompt response is greatly appreciated.

Thanks
Re: Loading Multiples excel files to multiple tables [message #549362 is a reply to message #549357] Thu, 29 March 2012 17:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I have a bunch of data in 50 excel files.
If these files really are Excel files, then Oracle does not know how to read (& process) them.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Loading Multiples excel files to multiple tables [message #549364 is a reply to message #549362] Thu, 29 March 2012 18:12 Go to previous messageGo to next message
gentleman777us
Messages: 122
Registered: April 2005
Senior Member
I can use .csv file. All Iam looking is how to load multiple .dat files into multiple tables.

Re: Loading Multiples excel files to multiple tables [message #549365 is a reply to message #549364] Thu, 29 March 2012 18:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
you will require a custom control file for each table to be loaded
Re: Loading Multiples excel files to multiple tables [message #549702 is a reply to message #549365] Tue, 03 April 2012 03:30 Go to previous messageGo to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

create the stored procedure with external table script and pass the parameter filename and target tablename.
Re: Loading Multiples excel files to multiple tables [message #549704 is a reply to message #549702] Tue, 03 April 2012 03:34 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
That assumes the tables have the same structure.
Previous Topic: sqlldr - datatype
Next Topic: SQL Loader TRIM in WHEN clause
Goto Forum:
  


Current Time: Thu Mar 28 13:21:41 CDT 2024