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: 345
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
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: 58545
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
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: 345
Registered: May 2008
Senior Member
I am sorry it is a excel sheet
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: 58545
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot load an excel file using SQL*Loader.

Regards
Michel
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: 345
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
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: 58545
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: SQL loader [message #473343 is a reply to message #473271] Fri, 27 August 2010 08:04 Go to previous message
BlackSwan
Messages: 22495
Registered: January 2009
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.
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:
  


Current Time: Thu Jul 24 22:55:33 CDT 2014

Total time taken to generate the page: 0.10366 seconds