Home » RDBMS Server » Server Utilities » SQL loader (oracle 10.2.0.3)
SQL loader [message #473254] Fri, 27 August 2010 01:23 Go to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
Hi,

I got an csv file which got 52 sheets. Is there a way from sqlloder to load all these 52 sheets data.
I in general seperate all these sheets into different CSV files and load. So, is there a better way to load.


Regards,
Pointers

Report message to a moderator

Re: SQL loader [message #473259 is a reply to message #473254] Fri, 27 August 2010 01:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A CSV file has no sheet, it is just a text file.

Regards
Michel

Report message to a moderator

Re: SQL loader [message #473260 is a reply to message #473259] Fri, 27 August 2010 01:47 Go to previous messageGo to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
I am sorry it is a excel sheet

Report message to a moderator

Re: SQL loader [message #473264 is a reply to message #473260] Fri, 27 August 2010 02:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot load an excel file using SQL*Loader.

Regards
Michel

Report message to a moderator

Re: SQL loader [message #473265 is a reply to message #473264] Fri, 27 August 2010 02:14 Go to previous messageGo to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
Yes true. Now i have only one way copy each sheet data into sepearate CSV file and load into the table. Do you see any other good way

Report message to a moderator

Re: SQL loader [message #473271 is a reply to message #473265] Fri, 27 August 2010 02:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel

Report message to a moderator

Re: SQL loader [message #473343 is a reply to message #473271] Fri, 27 August 2010 08:04 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> Do you see any other good way

Automate loading of data from Excel spreadsheets into database
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:243814703172

Install Oracle client software on Windows system running Excel.
Then connect Excel to Oracle DB via ODBC protocol & issue SQL directly from Excel against the DB
Any solution only involve Excel & Micro$oft, as Oracle is just data recipient.

Report message to a moderator

Previous Topic: Re: SQL Loader loads all fields with double quotes into staging table (split from unrelated hijacke
Next Topic: input variable in sqlloader ctl
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 21:50:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.